PREVIEW / etf_30min / 2020-07-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-13.parquet
  size:    570 KB
  rows:    21,485

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-07-13 04:00:00	SPY	ETF	319.0	319.21	318.76	318.93	92680.0
2020-07-13 04:30:00	SPY	ETF	318.95	318.98	318.45	318.83	11782.0
2020-07-13 05:00:00	SPY	ETF	319.0	319.2	318.67	318.86	65143.0
2020-07-13 05:30:00	SPY	ETF	318.92	319.34	318.83	319.34	12464.0
2020-07-13 06:00:00	SPY	ETF	319.28	319.42	319.02	319.35	16261.0
2020-07-13 06:30:00	SPY	ETF	319.31	319.83	319.13	319.78	33479.0
2020-07-13 07:00:00	SPY	ETF	319.74	320.51	319.7	320.2	113014.0
2020-07-13 07:30:00	SPY	ETF	320.22	320.35	320.11	320.25	128336.0
2020-07-13 08:00:00	SPY	ETF	320.29	320.4402	319.1704	319.94	216455.0
2020-07-13 08:30:00	SPY	ETF	320.04	320.19	319.85	320.0	178375.0
2020-07-13 09:00:00	SPY	ETF	320.01	320.3	319.97	320.11	196455.0
2020-07-13 09:30:00	SPY	ETF	320.13	320.44	319.49	319.59	6214738.0
2020-07-13 10:00:00	SPY	ETF	319.6	321.12	319.225	321.09	5133068.0
2020-07-13 10:30:00	SPY	ETF	321.11	321.67	320.43	321.65	3937086.0
2020-07-13 11:00:00	SPY	ETF	321.67	322.34	321.51	322.24	4667459.0
2020-07-13 11:30:00	SPY	ETF	322.245	322.35	321.45	321.72	3421308.0
2020-07-13 12:00:00	SPY	ETF	321.73	322.03	321.55	321.79	2535538.0
2020-07-13 12:30:00	SPY	ETF	321.795	322.03	321.54	321.65	2736480.0
2020-07-13 13:00:00	SPY	ETF	321.66	322.46	321.55	322.265	5678434.0
2020-07-13 13:30:00	SPY	ETF	322.265	322.71	321.85	321.92	2706823.0
2020-07-13 14:00:00	SPY	ETF	321.91	322.06	319.77	319.88	7275815.0
2020-07-13 14:30:00	SPY	ETF	319.88	320.63	319.07	320.41	6281719.0
2020-07-13 15:00:00	SPY	ETF	320.4	320.51	317.09	317.11	11061811.0
2020-07-13 15:30:00	SPY	ETF	317.1	317.6578	314.13	314.81	26321227.0
2020-07-13 16:00:00	SPY	ETF	314.82	315.29	314.23	315.24	11475880.0
2020-07-13 16:30:00	SPY	ETF	315.17	315.17	314.69	314.96	770239.0
2020-07-13 17:00:00	SPY	ETF	314.94	315.09	314.84	314.9	136581.0
2020-07-13 17:30:00	SPY	ETF	314.9	315.14	314.67	315.12	122424.0
2020-07-13 18:00:00	SPY	ETF	315.19	316.0	314.84	315.97	156927.0
2020-07-13 18:30:00	SPY	ETF	316.0	316.03	315.26	315.33	71136.0
2020-07-13 19:00:00	SPY	ETF	315.43	315.8	315.43	315.67	34132.0
2020-07-13 19:30:00	SPY	ETF	315.701	316.09	315.42	315.6	183989.0
2020-07-13 04:00:00	QQQ	ETF	265.58	265.72	265.41	265.5	50317.0
2020-07-13 04:30:00	QQQ	ETF	265.41	265.62	265.21	265.5	11799.0
2020-07-13 05:00:00	QQQ	ETF	265.7	265.75	265.32	265.42	18255.0
2020-07-13 05:30:00	QQQ	ETF	265.49	265.89	265.49	265.84	17615.0
2020-07-13 06:00:00	QQQ	ETF	265.76	266.01	265.7	265.93	15535.0
2020-07-13 06:30:00	QQQ	ETF	265.9	266.18	265.74	266.17	15950.0
2020-07-13 07:00:00	QQQ	ETF	266.11	266.85	266.11	266.62	135697.0
2020-07-13 07:30:00	QQQ	ETF	266.67	266.93	266.61	266.85	53208.0
2020-07-13 08:00:00	QQQ	ETF	266.6299	267.1	265.47	266.74	157047.0
2020-07-13 08:30:00	QQQ	ETF	266.729	266.95	266.64	266.85	79151.0
2020-07-13 09:00:00	QQQ	ETF	266.85	267.01	266.7	266.81	308459.0
2020-07-13 09:30:00	QQQ	ETF	266.86	268.3	266.68	267.52	4418862.0
2020-07-13 10:00:00	QQQ	ETF	267.53	268.395	267.0	268.351	2342883.0
2020-07-13 10:30:00	QQQ	ETF	268.3499	269.09	267.79	269.06	2423197.0
2020-07-13 11:00:00	QQQ	ETF	269.07	269.75	268.86	269.65	2306176.0
2020-07-13 11:30:00	QQQ	ETF	269.66	269.79	268.77	269.17	1761589.0
2020-07-13 12:00:00	QQQ	ETF	269.18	269.37	268.8	269.09	1803842.0
2020-07-13 12:30:00	QQQ	ETF	269.1	269.159	267.49	267.5233	1932893.0

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

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