PREVIEW / etf_30min / 2020-03-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-27.parquet
  size:    601 KB
  rows:    22,191

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-03-27 04:00:00	SPY	ETF	257.11	258.39	256.63	257.77	191500.0
2020-03-27 04:30:00	SPY	ETF	257.72	257.86	256.47	256.52	174923.0
2020-03-27 05:00:00	SPY	ETF	256.59	257.51	255.92	256.25	180799.0
2020-03-27 05:30:00	SPY	ETF	256.11	256.5	255.4	255.48	186128.0
2020-03-27 06:00:00	SPY	ETF	255.44	256.05	254.62	255.07	265726.0
2020-03-27 06:30:00	SPY	ETF	255.15	257.14	254.33	254.36	249526.0
2020-03-27 07:00:00	SPY	ETF	254.57	256.28	254.46	254.57	572692.0
2020-03-27 07:30:00	SPY	ETF	254.6	255.5	253.44	253.68	1007928.0
2020-03-27 08:00:00	SPY	ETF	253.67	260.42	252.98	255.3302	1623021.0
2020-03-27 08:30:00	SPY	ETF	255.34	256.01	253.05	253.11	1432895.0
2020-03-27 09:00:00	SPY	ETF	253.06	253.84	252.02	253.26	1776475.0
2020-03-27 09:30:00	SPY	ETF	253.27	254.98	251.05	253.17	24633757.0
2020-03-27 10:00:00	SPY	ETF	253.17	254.59	252.15	252.88	12733579.0
2020-03-27 10:30:00	SPY	ETF	252.88	253.7	251.92	253.17	10233321.0
2020-03-27 11:00:00	SPY	ETF	253.22	256.225	252.2	254.46	12747260.0
2020-03-27 11:30:00	SPY	ETF	254.43	255.13	252.45	252.68	10129085.0
2020-03-27 12:00:00	SPY	ETF	252.66	254.05	252.2	253.35	9872377.0
2020-03-27 12:30:00	SPY	ETF	253.34	255.21	253.03	255.145	7527256.0
2020-03-27 13:00:00	SPY	ETF	255.14	255.7	253.6905	254.0923	8745166.0
2020-03-27 13:30:00	SPY	ETF	254.11	257.3	253.9	255.6699	11596351.0
2020-03-27 14:00:00	SPY	ETF	255.67	256.8	254.87	256.34	12188685.0
2020-03-27 14:30:00	SPY	ETF	256.35	257.71	255.57	257.6	10121236.0
2020-03-27 15:00:00	SPY	ETF	257.62	260.81	257.0172	259.77	17924674.0
2020-03-27 15:30:00	SPY	ETF	259.77	260.0194	252.55	253.39	43009346.0
2020-03-27 16:00:00	SPY	ETF	253.38	262.1279	252.25	253.01	18503162.0
2020-03-27 16:30:00	SPY	ETF	253.0	253.42	252.03	252.34	1966570.0
2020-03-27 17:00:00	SPY	ETF	252.66	252.87	252.15	252.82	170932.0
2020-03-27 17:30:00	SPY	ETF	252.83	253.42	252.5	252.65	474981.0
2020-03-27 18:00:00	SPY	ETF	252.65	253.42	252.64	252.9	896234.0
2020-03-27 18:30:00	SPY	ETF	252.9	252.93	252.64	252.65	70967.0
2020-03-27 19:00:00	SPY	ETF	252.65	252.79	252.41	252.4999	45954.0
2020-03-27 19:30:00	SPY	ETF	252.5	252.64	252.09	252.1	98292.0
2020-03-27 04:00:00	QQQ	ETF	188.53	189.16	187.97	189.02	29643.0
2020-03-27 04:30:00	QQQ	ETF	189.12	189.28	188.4	188.42	57780.0
2020-03-27 05:00:00	QQQ	ETF	188.42	189.03	187.79	187.82	74746.0
2020-03-27 05:30:00	QQQ	ETF	187.71	188.05	187.48	187.49	27273.0
2020-03-27 06:00:00	QQQ	ETF	187.45	187.8	186.92	187.32	41028.0
2020-03-27 06:30:00	QQQ	ETF	187.37	188.66	187.04	187.04	62351.0
2020-03-27 07:00:00	QQQ	ETF	187.13	188.32	187.13	187.28	182736.0
2020-03-27 07:30:00	QQQ	ETF	187.25	187.5	186.38	186.7	245640.0
2020-03-27 08:00:00	QQQ	ETF	186.6	190.6	186.19	187.51	300669.0
2020-03-27 08:30:00	QQQ	ETF	187.55	187.92	186.58	186.71	386194.0
2020-03-27 09:00:00	QQQ	ETF	186.67	187.34	186.2	187.02	425304.0
2020-03-27 09:30:00	QQQ	ETF	186.98	187.84	185.06	186.39	5537018.0
2020-03-27 10:00:00	QQQ	ETF	186.43	187.1	185.48	185.845	3810293.0
2020-03-27 10:30:00	QQQ	ETF	185.84	186.24	185.29	185.89	2363847.0
2020-03-27 11:00:00	QQQ	ETF	185.9178	187.99	185.9178	186.79	3196887.0
2020-03-27 11:30:00	QQQ	ETF	186.76	187.22	185.63	185.675	2796096.0
2020-03-27 12:00:00	QQQ	ETF	185.68	186.3	185.18	185.91	2813318.0
2020-03-27 12:30:00	QQQ	ETF	185.9	186.96	185.67	186.89	2068684.0

> showing 50 of 22,191 rows — these rows as CSV

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