PREVIEW / etf_30min / 2008-03-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-24.parquet
  size:    161 KB
  rows:    5,843

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-03-24 04:00:00	SPY	ETF	132.79	132.79	132.62	132.66	600.0
2008-03-24 04:30:00	SPY	ETF	132.7	132.7	132.7	132.7	4000.0
2008-03-24 05:00:00	SPY	ETF	132.96	132.96	132.96	132.96	600.0
2008-03-24 06:00:00	SPY	ETF	132.93	132.95	132.93	132.95	12500.0
2008-03-24 06:30:00	SPY	ETF	132.9	133.0	132.74	132.74	35600.0
2008-03-24 07:00:00	SPY	ETF	132.71	133.19	132.67	133.16	304000.0
2008-03-24 07:30:00	SPY	ETF	133.13	133.14	132.93	133.05	143400.0
2008-03-24 08:00:00	SPY	ETF	133.05	133.2	132.93	133.2	934600.0
2008-03-24 08:30:00	SPY	ETF	133.19	133.51	133.14	133.43	1962500.0
2008-03-24 09:00:00	SPY	ETF	133.42	133.5	132.55	133.31	919400.0
2008-03-24 09:30:00	SPY	ETF	133.31	134.45	133.24	134.26	32849063.0
2008-03-24 10:00:00	SPY	ETF	134.26	135.13	134.1399	134.73	28384591.0
2008-03-24 10:30:00	SPY	ETF	134.73	135.38	134.68	134.98	14143613.0
2008-03-24 11:00:00	SPY	ETF	134.98	135.19	134.79	135.15	11775316.0
2008-03-24 11:30:00	SPY	ETF	135.1475	135.59	135.07	135.21	12275806.0
2008-03-24 12:00:00	SPY	ETF	135.22	135.43	134.9	135.39	8270490.0
2008-03-24 12:30:00	SPY	ETF	135.39	135.81	135.29	135.51	9964808.0
2008-03-24 13:00:00	SPY	ETF	135.51	135.65	135.4	135.55	7980413.0
2008-03-24 13:30:00	SPY	ETF	135.55	135.66	135.37	135.65	6716949.0
2008-03-24 14:00:00	SPY	ETF	135.65	135.66	135.17	135.43	9884621.0
2008-03-24 14:30:00	SPY	ETF	135.44	135.53	134.92	134.98	10329127.0
2008-03-24 15:00:00	SPY	ETF	134.97	135.31	134.77	134.802	13439564.0
2008-03-24 15:30:00	SPY	ETF	134.8	135.1	134.44	134.77	29898893.0
2008-03-24 16:00:00	SPY	ETF	134.81	135.4	134.6	134.79	2785800.0
2008-03-24 16:30:00	SPY	ETF	134.79	134.9	134.72	134.75	3207600.0
2008-03-24 17:00:00	SPY	ETF	134.75	134.85	132.75	134.83	456900.0
2008-03-24 17:30:00	SPY	ETF	134.84	134.84	134.75	134.83	12500.0
2008-03-24 18:00:00	SPY	ETF	134.83	135.33	134.83	135.29	189400.0
2008-03-24 18:30:00	SPY	ETF	135.29	135.33	135.13	135.17	31600.0
2008-03-24 19:00:00	SPY	ETF	135.2	135.2	135.06	135.1	18600.0
2008-03-24 19:30:00	SPY	ETF	135.1	135.14	135.03	135.14	12900.0
2008-03-24 06:00:00	QQQ	ETF	43.05	43.05	43.05	43.05	4000.0
2008-03-24 06:30:00	QQQ	ETF	43.11	43.11	43.06	43.08	3100.0
2008-03-24 07:00:00	QQQ	ETF	43.03	43.15	43.03	43.15	36889.0
2008-03-24 07:30:00	QQQ	ETF	43.14	43.16	43.1	43.11	76562.0
2008-03-24 08:00:00	QQQ	ETF	43.12	43.16	43.09	43.14	497821.0
2008-03-24 08:30:00	QQQ	ETF	43.14	43.32	43.14	43.28	1380463.0
2008-03-24 09:00:00	QQQ	ETF	43.27	43.36	43.18	43.29	1716472.0
2008-03-24 09:30:00	QQQ	ETF	43.29	43.7	43.28	43.66	20406299.0
2008-03-24 10:00:00	QQQ	ETF	43.66	44.24	43.6301	44.1799	18384274.0
2008-03-24 10:30:00	QQQ	ETF	44.17	44.4	44.17	44.2	10120100.0
2008-03-24 11:00:00	QQQ	ETF	44.2	44.39	44.18	44.34	4813305.0
2008-03-24 11:30:00	QQQ	ETF	44.35	44.54	44.32	44.45	5983666.0
2008-03-24 12:00:00	QQQ	ETF	44.45	44.62	44.38	44.6	5254681.0
2008-03-24 12:30:00	QQQ	ETF	44.61	44.74	44.58	44.62	7201753.0
2008-03-24 13:00:00	QQQ	ETF	44.62	44.72	44.56	44.6914	3342079.0
2008-03-24 13:30:00	QQQ	ETF	44.7	44.76	44.6	44.76	5325306.0
2008-03-24 14:00:00	QQQ	ETF	44.76	44.76	44.55	44.68	4467572.0
2008-03-24 14:30:00	QQQ	ETF	44.68	44.73	44.45	44.47	6468895.0
2008-03-24 15:00:00	QQQ	ETF	44.47	44.67	44.43	44.51	9427640.0

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

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