PREVIEW / etf_30min / 2008-05-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-19.parquet
  size:    170 KB
  rows:    5,866

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
2008-05-19 04:00:00	SPY	ETF	142.6	142.6	142.6	142.6	15000.0
2008-05-19 04:30:00	SPY	ETF	142.63	142.63	142.5	142.5	17700.0
2008-05-19 05:00:00	SPY	ETF	142.47	142.53	142.47	142.53	7700.0
2008-05-19 05:30:00	SPY	ETF	142.67	142.69	142.67	142.69	15000.0
2008-05-19 06:00:00	SPY	ETF	142.74	142.77	142.74	142.77	2400.0
2008-05-19 06:30:00	SPY	ETF	142.78	142.79	142.69	142.73	3900.0
2008-05-19 07:00:00	SPY	ETF	142.72	142.76	142.61	142.66	372700.0
2008-05-19 07:30:00	SPY	ETF	142.65	142.73	142.62	142.69	327400.0
2008-05-19 08:00:00	SPY	ETF	142.71	142.81	142.5	142.73	823120.0
2008-05-19 08:30:00	SPY	ETF	142.75	142.77	142.69	142.74	132417.0
2008-05-19 09:00:00	SPY	ETF	142.74	142.81	142.71	142.81	606420.0
2008-05-19 09:30:00	SPY	ETF	142.81	143.09	142.49	143.06	17459039.0
2008-05-19 10:00:00	SPY	ETF	143.06	143.39	142.97	143.29	13457867.0
2008-05-19 10:30:00	SPY	ETF	143.29	143.6	143.26	143.44	10607973.0
2008-05-19 11:00:00	SPY	ETF	143.44	143.88	143.38	143.78	9835976.0
2008-05-19 11:30:00	SPY	ETF	143.77	144.07	143.74	143.91	13015165.0
2008-05-19 12:00:00	SPY	ETF	143.9	144.07	143.83	144.01	8040762.0
2008-05-19 12:30:00	SPY	ETF	144.02	144.13	143.86	143.93	5803518.0
2008-05-19 13:00:00	SPY	ETF	143.93	144.3	143.91	144.19	6923277.0
2008-05-19 13:30:00	SPY	ETF	144.2	144.2	143.65	143.68	8380200.0
2008-05-19 14:00:00	SPY	ETF	143.68	143.71	142.84	142.97	21650577.0
2008-05-19 14:30:00	SPY	ETF	142.97	143.27	142.95	143.24	9928984.0
2008-05-19 15:00:00	SPY	ETF	143.24	143.34	142.99	143.09	8552039.0
2008-05-19 15:30:00	SPY	ETF	143.1	143.12	142.3	142.83	23421296.0
2008-05-19 16:00:00	SPY	ETF	142.83	143.14	142.55	143.02	3315722.0
2008-05-19 16:30:00	SPY	ETF	143.03	143.05	142.93	142.98	311857.0
2008-05-19 17:00:00	SPY	ETF	142.99	143.05	142.98	143.02	717233.0
2008-05-19 17:30:00	SPY	ETF	143.04	143.04	143.0	143.0	4328.0
2008-05-19 18:00:00	SPY	ETF	143.02	143.04	142.99	143.04	27710.0
2008-05-19 18:30:00	SPY	ETF	143.02	143.02	142.98	142.98	1800.0
2008-05-19 19:00:00	SPY	ETF	143.0	143.01	142.97	142.97	2480.0
2008-05-19 19:30:00	SPY	ETF	142.97	143.04	142.97	143.04	3675.0
2008-05-19 04:00:00	QQQ	ETF	50.0	50.0	50.0	50.0	2000.0
2008-05-19 06:30:00	QQQ	ETF	50.02	50.03	50.0	50.0	7000.0
2008-05-19 07:00:00	QQQ	ETF	50.0	50.04	50.0	50.03	27037.0
2008-05-19 07:30:00	QQQ	ETF	50.0	50.04	49.99	50.02	170900.0
2008-05-19 08:00:00	QQQ	ETF	50.01	50.08	49.99	50.05	135782.0
2008-05-19 08:30:00	QQQ	ETF	50.05	50.09	50.02	50.07	122085.0
2008-05-19 09:00:00	QQQ	ETF	50.08	50.09	50.05	50.06	215374.0
2008-05-19 09:30:00	QQQ	ETF	50.05	50.19	49.88	50.189	15255556.0
2008-05-19 10:00:00	QQQ	ETF	50.18	50.36	50.12	50.22	10774958.0
2008-05-19 10:30:00	QQQ	ETF	50.21	50.32	50.13	50.195	6680216.0
2008-05-19 11:00:00	QQQ	ETF	50.19	50.36	50.13	50.3	6902412.0
2008-05-19 11:30:00	QQQ	ETF	50.3	50.43	50.28	50.329	5951799.0
2008-05-19 12:00:00	QQQ	ETF	50.33	50.39	50.29	50.33	3799611.0
2008-05-19 12:30:00	QQQ	ETF	50.3398	50.37	50.28	50.3099	3194623.0
2008-05-19 13:00:00	QQQ	ETF	50.31	50.47	50.31	50.4497	4092932.0
2008-05-19 13:30:00	QQQ	ETF	50.45	50.45	50.08	50.09	6663902.0
2008-05-19 14:00:00	QQQ	ETF	50.09	50.1	49.6	49.65	17807457.0
2008-05-19 14:30:00	QQQ	ETF	49.66	49.9	49.65	49.8995	11456115.0

> showing 50 of 5,866 rows — these rows as CSV

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