PREVIEW / etf_30min / 2020-11-12

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-12.parquet
  size:    585 KB
  rows:    21,422

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-11-12 04:00:00	SPY	ETF	354.7	355.31	354.57	355.16	34047.0
2020-11-12 04:30:00	SPY	ETF	355.29	356.26	355.29	356.06	22548.0
2020-11-12 05:00:00	SPY	ETF	356.16	356.41	356.04	356.14	17368.0
2020-11-12 05:30:00	SPY	ETF	356.16	356.86	356.16	356.44	12011.0
2020-11-12 06:00:00	SPY	ETF	356.37	356.81	356.28	356.3	44612.0
2020-11-12 06:30:00	SPY	ETF	356.36	356.47	355.99	355.99	27334.0
2020-11-12 07:00:00	SPY	ETF	355.99	356.1	354.68	355.61	199074.0
2020-11-12 07:30:00	SPY	ETF	355.57	355.7	354.36	354.5	162586.0
2020-11-12 08:00:00	SPY	ETF	354.8801	356.4396	354.01	355.39	221897.0
2020-11-12 08:30:00	SPY	ETF	355.29	355.85	355.1	355.78	181640.0
2020-11-12 09:00:00	SPY	ETF	355.8	355.88	355.09	355.6	502442.0
2020-11-12 09:30:00	SPY	ETF	355.58	355.84	354.67	355.34	5473399.0
2020-11-12 10:00:00	SPY	ETF	355.33	356.24	354.96	355.36	3707286.0
2020-11-12 10:30:00	SPY	ETF	355.35	356.39	355.27	356.0	2181622.0
2020-11-12 11:00:00	SPY	ETF	356.0092	356.42	355.44	355.65	2249667.0
2020-11-12 11:30:00	SPY	ETF	355.65	356.7182	354.7008	355.25	3141329.0
2020-11-12 12:00:00	SPY	ETF	355.23	355.64	354.23	354.27	2250371.0
2020-11-12 12:30:00	SPY	ETF	354.26	354.66	352.51	353.28	4887505.0
2020-11-12 13:00:00	SPY	ETF	353.27	353.3745	351.97	352.25	4561760.0
2020-11-12 13:30:00	SPY	ETF	352.25	353.5	351.97	353.46	3863498.0
2020-11-12 14:00:00	SPY	ETF	353.46	353.88	352.27	352.69	4223598.0
2020-11-12 14:30:00	SPY	ETF	352.68	353.37	351.83	352.0299	4036941.0
2020-11-12 15:00:00	SPY	ETF	352.03	352.67	351.26	351.94	5472670.0
2020-11-12 15:30:00	SPY	ETF	351.93	353.33	351.35	353.28	12647007.0
2020-11-12 16:00:00	SPY	ETF	353.27	354.27	353.165	353.85	4612453.0
2020-11-12 16:30:00	SPY	ETF	353.83	354.64	353.72	353.87	641438.0
2020-11-12 17:00:00	SPY	ETF	353.7	353.82	353.7	353.76	275977.0
2020-11-12 17:30:00	SPY	ETF	353.75	353.94	353.7	353.82	24144.0
2020-11-12 18:00:00	SPY	ETF	353.77	353.91	353.2	353.65	364221.0
2020-11-12 18:30:00	SPY	ETF	353.64	353.8	353.31	353.35	62640.0
2020-11-12 19:00:00	SPY	ETF	353.4	353.78	353.3	353.71	45427.0
2020-11-12 19:30:00	SPY	ETF	353.7	353.7	352.68	352.7	137475.0
2020-11-12 04:00:00	QQQ	ETF	289.16	289.86	289.02	289.83	13755.0
2020-11-12 04:30:00	QQQ	ETF	289.93	291.36	289.93	291.34	38432.0
2020-11-12 05:00:00	QQQ	ETF	291.45	291.82	291.17	291.26	40211.0
2020-11-12 05:30:00	QQQ	ETF	291.1	291.45	291.1	291.23	21975.0
2020-11-12 06:00:00	QQQ	ETF	291.32	291.52	290.79	291.3	36763.0
2020-11-12 06:30:00	QQQ	ETF	291.25	291.3	290.98	291.01	23360.0
2020-11-12 07:00:00	QQQ	ETF	290.89	291.06	289.68	290.52	184110.0
2020-11-12 07:30:00	QQQ	ETF	290.55	290.7	290.04	290.06	207001.0
2020-11-12 08:00:00	QQQ	ETF	290.21	291.3396	287.96	290.58	235275.0
2020-11-12 08:30:00	QQQ	ETF	290.4	291.13	290.35	290.68	186167.0
2020-11-12 09:00:00	QQQ	ETF	290.68	290.7	290.3	290.69	164432.0
2020-11-12 09:30:00	QQQ	ETF	290.71	291.83	289.83	290.915	4504063.0
2020-11-12 10:00:00	QQQ	ETF	290.89	291.8	290.46	290.94	2120451.0
2020-11-12 10:30:00	QQQ	ETF	290.9599	292.074	290.82	290.94	1829209.0
2020-11-12 11:00:00	QQQ	ETF	290.95	291.61	290.22	290.64	1384271.0
2020-11-12 11:30:00	QQQ	ETF	290.63	290.68	289.22	290.105	1726480.0
2020-11-12 12:00:00	QQQ	ETF	290.11	290.62	289.33	289.3846	1310551.0
2020-11-12 12:30:00	QQQ	ETF	289.4099	289.9777	287.97	288.705	2294964.0

> showing 50 of 21,422 rows — these rows as CSV

> unlock the full archive -- $79 one-time