PREVIEW / etf_30min / 2020-01-28

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-28.parquet
  size:    546 KB
  rows:    19,165

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-28 04:00:00	SPY	ETF	324.5	324.5	323.85	323.96	26964.0
2020-01-28 04:30:00	SPY	ETF	324.0	324.5	324.0	324.2	11252.0
2020-01-28 05:00:00	SPY	ETF	324.24	324.4	323.95	323.96	10443.0
2020-01-28 05:30:00	SPY	ETF	324.11	324.38	324.11	324.2	3775.0
2020-01-28 06:00:00	SPY	ETF	324.11	324.12	323.56	324.03	23323.0
2020-01-28 06:30:00	SPY	ETF	324.08	324.97	324.08	324.92	41994.0
2020-01-28 07:00:00	SPY	ETF	324.89	325.3	324.65	325.28	134639.0
2020-01-28 07:30:00	SPY	ETF	325.24	325.64	325.16	325.25	248933.0
2020-01-28 08:00:00	SPY	ETF	325.25	325.61	323.5	325.41	493604.0
2020-01-28 08:30:00	SPY	ETF	325.42	325.56	325.15	325.24	182033.0
2020-01-28 09:00:00	SPY	ETF	325.24	325.31	325.01	325.04	432251.0
2020-01-28 09:30:00	SPY	ETF	325.06	325.49	324.55	325.11	6328525.0
2020-01-28 10:00:00	SPY	ETF	325.115	326.6	325.115	326.3599	7263850.0
2020-01-28 10:30:00	SPY	ETF	326.34	327.0199	326.24	326.86	5014400.0
2020-01-28 11:00:00	SPY	ETF	326.85	327.0999	326.44	327.0	3589090.0
2020-01-28 11:30:00	SPY	ETF	327.0	327.26	326.76	327.21	2189141.0
2020-01-28 12:00:00	SPY	ETF	327.22	327.46	327.0327	327.3755	2318626.0
2020-01-28 12:30:00	SPY	ETF	327.38	327.405	327.0	327.12	1919445.0
2020-01-28 13:00:00	SPY	ETF	327.11	327.1121	326.69	326.87	2408194.0
2020-01-28 13:30:00	SPY	ETF	326.86	327.19	326.63	327.09	2199070.0
2020-01-28 14:00:00	SPY	ETF	327.093	327.58	327.09	327.34	3569169.0
2020-01-28 14:30:00	SPY	ETF	327.3461	327.85	327.33	327.43	4116756.0
2020-01-28 15:00:00	SPY	ETF	327.44	327.68	327.17	327.67	2965760.0
2020-01-28 15:30:00	SPY	ETF	327.665	327.69	326.79	326.89	10895897.0
2020-01-28 16:00:00	SPY	ETF	326.89	327.28	323.6038	327.02	4429609.0
2020-01-28 16:30:00	SPY	ETF	327.04	327.75	327.04	327.6	681071.0
2020-01-28 17:00:00	SPY	ETF	327.6	327.81	326.89	327.53	180290.0
2020-01-28 17:30:00	SPY	ETF	327.59	327.7	327.5	327.5	45073.0
2020-01-28 18:00:00	SPY	ETF	327.57	327.6	326.71	326.88	155102.0
2020-01-28 18:30:00	SPY	ETF	326.89	327.07	326.85	326.85	35281.0
2020-01-28 19:00:00	SPY	ETF	326.83	326.9	326.68	326.68	78118.0
2020-01-28 19:30:00	SPY	ETF	326.7	326.89	326.7	326.79	41884.0
2020-01-28 04:00:00	QQQ	ETF	219.05	219.05	218.42	218.62	48206.0
2020-01-28 04:30:00	QQQ	ETF	218.67	218.98	218.67	218.93	15751.0
2020-01-28 05:00:00	QQQ	ETF	218.84	219.07	218.73	218.73	25563.0
2020-01-28 05:30:00	QQQ	ETF	218.8	219.03	218.79	218.91	16291.0
2020-01-28 06:00:00	QQQ	ETF	218.8	218.9	218.49	218.9	18967.0
2020-01-28 06:30:00	QQQ	ETF	218.95	219.47	218.86	219.46	44352.0
2020-01-28 07:00:00	QQQ	ETF	219.44	219.73	219.25	219.73	93438.0
2020-01-28 07:30:00	QQQ	ETF	219.69	219.99	219.66	219.76	314829.0
2020-01-28 08:00:00	QQQ	ETF	219.3499	219.95	218.1	219.8	184181.0
2020-01-28 08:30:00	QQQ	ETF	219.79	219.94	219.65	219.73	164913.0
2020-01-28 09:00:00	QQQ	ETF	219.7	219.79	219.56	219.61	169866.0
2020-01-28 09:30:00	QQQ	ETF	219.6	219.98	219.06	219.47	2762725.0
2020-01-28 10:00:00	QQQ	ETF	219.49	220.44	219.43	220.26	2485088.0
2020-01-28 10:30:00	QQQ	ETF	220.27	220.95	220.2175	220.815	1899439.0
2020-01-28 11:00:00	QQQ	ETF	220.82	221.17	220.52	221.11	1541899.0
2020-01-28 11:30:00	QQQ	ETF	221.13	221.42	221.051	221.38	1096229.0
2020-01-28 12:00:00	QQQ	ETF	221.39	221.62	221.28	221.52	727616.0
2020-01-28 12:30:00	QQQ	ETF	221.53	221.62	221.23	221.321	792044.0

> showing 50 of 19,165 rows — these rows as CSV

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