PREVIEW / etf_30min / 2020-01-31

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-31.parquet
  size:    569 KB
  rows:    20,062

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-01-31 04:00:00	SPY	ETF	327.33	327.48	327.21	327.42	5488.0
2020-01-31 04:30:00	SPY	ETF	327.48	327.48	326.94	327.13	17206.0
2020-01-31 05:00:00	SPY	ETF	327.11	327.26	326.31	326.38	38485.0
2020-01-31 05:30:00	SPY	ETF	326.31	326.62	326.03	326.6	23794.0
2020-01-31 06:00:00	SPY	ETF	326.6	326.93	326.43	326.55	37179.0
2020-01-31 06:30:00	SPY	ETF	326.52	326.87	326.45	326.82	56206.0
2020-01-31 07:00:00	SPY	ETF	326.82	327.35	326.77	327.12	107304.0
2020-01-31 07:30:00	SPY	ETF	327.22	327.45	326.95	327.04	130612.0
2020-01-31 08:00:00	SPY	ETF	326.92	329.0	326.7	326.91	249191.0
2020-01-31 08:30:00	SPY	ETF	326.96	327.21	326.7	327.1	256256.0
2020-01-31 09:00:00	SPY	ETF	327.1	327.43	326.92	326.99	274248.0
2020-01-31 09:30:00	SPY	ETF	327.0	327.17	325.43	326.05	7566669.0
2020-01-31 10:00:00	SPY	ETF	326.03	326.035	324.66	324.66	5972759.0
2020-01-31 10:30:00	SPY	ETF	324.66	324.94	323.76	323.95	5221600.0
2020-01-31 11:00:00	SPY	ETF	323.96	324.34	322.795	323.01	7754495.0
2020-01-31 11:30:00	SPY	ETF	323.01	324.1	322.63	324.095	6194425.0
2020-01-31 12:00:00	SPY	ETF	324.095	324.095	323.12	323.42	3436633.0
2020-01-31 12:30:00	SPY	ETF	323.41	323.41	322.11	322.69	10419696.0
2020-01-31 13:00:00	SPY	ETF	322.6899	323.15	322.08	322.3666	4228029.0
2020-01-31 13:30:00	SPY	ETF	322.385	322.48	321.65	322.47	5203093.0
2020-01-31 14:00:00	SPY	ETF	322.48	322.97	322.18	322.36	4773175.0
2020-01-31 14:30:00	SPY	ETF	322.3501	323.23	322.24	322.49	4667484.0
2020-01-31 15:00:00	SPY	ETF	322.5	322.75	321.51	321.52	8555945.0
2020-01-31 15:30:00	SPY	ETF	321.5	322.18	320.73	321.74	20758842.0
2020-01-31 16:00:00	SPY	ETF	321.75	327.674	321.64	322.24	13605689.0
2020-01-31 16:30:00	SPY	ETF	322.19	322.34	321.73	322.17	1072544.0
2020-01-31 17:00:00	SPY	ETF	322.27	322.27	321.73	321.96	264335.0
2020-01-31 17:30:00	SPY	ETF	321.96	322.0	321.91	321.98	64881.0
2020-01-31 18:00:00	SPY	ETF	321.92	322.01	321.91	321.96	44138.0
2020-01-31 18:30:00	SPY	ETF	321.92	322.04	321.86	322.0	53823.0
2020-01-31 19:00:00	SPY	ETF	321.93	321.97	321.85	321.88	25070.0
2020-01-31 19:30:00	SPY	ETF	321.85	321.9	321.85	321.85	25777.0
2020-01-31 04:00:00	QQQ	ETF	223.5	223.61	223.4	223.58	49725.0
2020-01-31 04:30:00	QQQ	ETF	223.45	223.45	223.21	223.35	9120.0
2020-01-31 05:00:00	QQQ	ETF	223.3	223.47	222.79	222.79	27408.0
2020-01-31 05:30:00	QQQ	ETF	222.65	222.98	222.53	222.97	18957.0
2020-01-31 06:00:00	QQQ	ETF	223.0	223.28	222.89	222.97	19861.0
2020-01-31 06:30:00	QQQ	ETF	222.97	223.26	222.96	223.26	32314.0
2020-01-31 07:00:00	QQQ	ETF	223.27	223.88	223.25	223.69	106791.0
2020-01-31 07:30:00	QQQ	ETF	223.68	223.94	223.49	223.59	169902.0
2020-01-31 08:00:00	QQQ	ETF	223.7299	224.98	222.98	223.58	193554.0
2020-01-31 08:30:00	QQQ	ETF	223.57	223.77	223.36	223.63	205953.0
2020-01-31 09:00:00	QQQ	ETF	223.7	223.98	223.43	223.54	138676.0
2020-01-31 09:30:00	QQQ	ETF	223.51	223.56	221.595	222.24	4549870.0
2020-01-31 10:00:00	QQQ	ETF	222.24	222.32	220.79	220.81	3181051.0
2020-01-31 10:30:00	QQQ	ETF	220.8	221.22	220.39	220.63	2239005.0
2020-01-31 11:00:00	QQQ	ETF	220.59	220.98	219.57	219.8	3310521.0
2020-01-31 11:30:00	QQQ	ETF	219.8	220.87	219.44	220.865	2877904.0
2020-01-31 12:00:00	QQQ	ETF	220.86	220.86	220.035	220.4	1373935.0
2020-01-31 12:30:00	QQQ	ETF	220.37	220.375	219.51	219.9964	2549838.0

> showing 50 of 20,062 rows — these rows as CSV

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