PREVIEW / etf_30min / 2008-04-01

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-01.parquet
  size:    164 KB
  rows:    5,905

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-04-01 04:00:00	SPY	ETF	132.52	132.52	132.52	132.52	100.0
2008-04-01 04:30:00	SPY	ETF	132.59	132.66	132.59	132.66	1400.0
2008-04-01 05:00:00	SPY	ETF	132.63	132.63	132.63	132.63	1000.0
2008-04-01 05:30:00	SPY	ETF	132.78	133.0	132.78	133.0	20600.0
2008-04-01 06:00:00	SPY	ETF	132.94	133.08	132.94	133.08	27800.0
2008-04-01 06:30:00	SPY	ETF	132.94	133.11	132.94	133.0	41500.0
2008-04-01 07:00:00	SPY	ETF	133.06	133.06	132.87	132.96	298400.0
2008-04-01 07:30:00	SPY	ETF	132.93	133.18	132.85	133.07	1023400.0
2008-04-01 08:00:00	SPY	ETF	133.05	133.35	132.91	133.25	2003307.0
2008-04-01 08:30:00	SPY	ETF	133.26	133.62	131.97	133.49	1771600.0
2008-04-01 09:00:00	SPY	ETF	133.5	133.75	131.28	133.6	2454458.0
2008-04-01 09:30:00	SPY	ETF	133.61	134.19	133.51	134.03	21226317.0
2008-04-01 10:00:00	SPY	ETF	134.06	134.64	134.03	134.43	22780490.0
2008-04-01 10:30:00	SPY	ETF	134.42	135.1	134.4	135.04	17476752.0
2008-04-01 11:00:00	SPY	ETF	135.04	135.14	134.82	134.8691	10432788.0
2008-04-01 11:30:00	SPY	ETF	134.85	135.26	134.81	135.2	9478786.0
2008-04-01 12:00:00	SPY	ETF	135.2	135.7	134.85	135.62	14919294.0
2008-04-01 12:30:00	SPY	ETF	135.61	135.64	135.33	135.4	9725348.0
2008-04-01 13:00:00	SPY	ETF	135.39	135.91	135.3	135.83	14228902.0
2008-04-01 13:30:00	SPY	ETF	135.83	135.93	135.4	135.56	12166496.0
2008-04-01 14:00:00	SPY	ETF	135.56	135.93	135.35	135.69	12304781.0
2008-04-01 14:30:00	SPY	ETF	135.69	136.5	135.68	136.02	26321562.0
2008-04-01 15:00:00	SPY	ETF	136.02	136.48	136.01	136.32	16372519.0
2008-04-01 15:30:00	SPY	ETF	136.32	136.84	135.81	136.81	34047111.0
2008-04-01 16:00:00	SPY	ETF	136.781	136.85	133.61	136.65	4849400.0
2008-04-01 16:30:00	SPY	ETF	136.65	136.71	136.56	136.7	7944844.0
2008-04-01 17:00:00	SPY	ETF	136.7	136.89	136.61	136.85	9353500.0
2008-04-01 17:30:00	SPY	ETF	136.85	136.85	136.82	136.83	9400.0
2008-04-01 18:00:00	SPY	ETF	136.83	136.83	136.63	136.65	57700.0
2008-04-01 18:30:00	SPY	ETF	136.65	136.69	136.62	136.69	19600.0
2008-04-01 19:00:00	SPY	ETF	136.67	136.74	136.64	136.66	18100.0
2008-04-01 19:30:00	SPY	ETF	136.6	136.64	136.48	136.49	62500.0
2008-04-01 04:00:00	QQQ	ETF	44.03	44.07	44.03	44.07	400.0
2008-04-01 04:30:00	QQQ	ETF	44.14	44.14	44.14	44.14	1400.0
2008-04-01 05:00:00	QQQ	ETF	44.16	44.16	44.16	44.16	1000.0
2008-04-01 05:30:00	QQQ	ETF	44.25	44.28	44.22	44.28	2800.0
2008-04-01 06:00:00	QQQ	ETF	44.19	44.22	44.19	44.22	1000.0
2008-04-01 07:00:00	QQQ	ETF	44.27	44.3	44.21	44.21	58236.0
2008-04-01 07:30:00	QQQ	ETF	44.23	44.33	44.21	44.3	285449.0
2008-04-01 08:00:00	QQQ	ETF	44.27	44.4	44.24	44.34	1277595.0
2008-04-01 08:30:00	QQQ	ETF	44.33	44.45	44.33	44.44	1922555.0
2008-04-01 09:00:00	QQQ	ETF	44.43	44.5	44.41	44.45	2501777.0
2008-04-01 09:30:00	QQQ	ETF	44.45	44.65	44.41	44.56	10741338.0
2008-04-01 10:00:00	QQQ	ETF	44.57	44.78	44.568	44.69	10765035.0
2008-04-01 10:30:00	QQQ	ETF	44.68	44.9	44.67	44.87	9255798.0
2008-04-01 11:00:00	QQQ	ETF	44.86	45.0	44.86	44.92	6609685.0
2008-04-01 11:30:00	QQQ	ETF	44.92	45.05	44.9	45.03	6513667.0
2008-04-01 12:00:00	QQQ	ETF	45.03	45.21	45.02	45.178	8198726.0
2008-04-01 12:30:00	QQQ	ETF	45.17	45.19	45.07	45.0708	3644000.0
2008-04-01 13:00:00	QQQ	ETF	45.08	45.34	45.06	45.31	9092351.0

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

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