PREVIEW / etf_30min / 2008-01-28

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-28.parquet
  size:    158 KB
  rows:    5,718

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-01-28 04:00:00	SPY	ETF	132.49	132.49	132.49	132.49	200.0
2008-01-28 05:00:00	SPY	ETF	132.04	132.04	132.0	132.0	700.0
2008-01-28 06:00:00	SPY	ETF	132.1	132.22	132.1	132.22	19600.0
2008-01-28 06:30:00	SPY	ETF	132.08	132.27	132.05	132.24	31800.0
2008-01-28 07:00:00	SPY	ETF	132.34	132.6	132.18	132.5	142500.0
2008-01-28 07:30:00	SPY	ETF	132.57	132.64	132.39	132.44	410200.0
2008-01-28 08:00:00	SPY	ETF	132.42	133.0	132.05	132.98	2195100.0
2008-01-28 08:30:00	SPY	ETF	132.99	133.04	132.52	132.77	1391100.0
2008-01-28 09:00:00	SPY	ETF	132.78	133.31	132.71	133.29	1537900.0
2008-01-28 09:30:00	SPY	ETF	133.26	133.33	132.29	132.88	21869892.0
2008-01-28 10:00:00	SPY	ETF	132.88	133.49	132.06	133.4	23685897.0
2008-01-28 10:30:00	SPY	ETF	133.41	134.08	133.1	133.82	20695070.0
2008-01-28 11:00:00	SPY	ETF	133.81	134.14	133.48	133.91	10892419.0
2008-01-28 11:30:00	SPY	ETF	133.9	134.45	133.84	133.89	9709971.0
2008-01-28 12:00:00	SPY	ETF	133.8999	134.03	133.46	133.66	7356423.0
2008-01-28 12:30:00	SPY	ETF	133.66	134.22	133.47	134.03	7099969.0
2008-01-28 13:00:00	SPY	ETF	134.04	134.68	133.98	134.29	15983152.0
2008-01-28 13:30:00	SPY	ETF	134.3	134.49	134.01	134.22	8770806.0
2008-01-28 14:00:00	SPY	ETF	134.22	134.78	134.22	134.5	8504864.0
2008-01-28 14:30:00	SPY	ETF	134.51	134.89	134.21	134.28	16365268.0
2008-01-28 15:00:00	SPY	ETF	134.28	134.54	133.73	134.11	18808170.0
2008-01-28 15:30:00	SPY	ETF	134.11	135.33	134.07	135.32	24289812.0
2008-01-28 16:00:00	SPY	ETF	135.26	135.51	132.85	135.23	8287400.0
2008-01-28 16:30:00	SPY	ETF	135.23	135.3	134.93	134.99	1881300.0
2008-01-28 17:00:00	SPY	ETF	135.06	135.5	135.02	135.38	1015000.0
2008-01-28 17:30:00	SPY	ETF	135.31	135.45	135.3	135.36	63800.0
2008-01-28 18:00:00	SPY	ETF	135.35	135.42	135.28	135.28	206900.0
2008-01-28 18:30:00	SPY	ETF	135.31	135.41	135.22	135.35	48100.0
2008-01-28 19:00:00	SPY	ETF	135.35	135.4	135.3	135.4	41400.0
2008-01-28 19:30:00	SPY	ETF	135.39	135.39	135.28	135.33	16600.0
2008-01-28 04:00:00	QQQ	ETF	43.76	43.76	43.76	43.76	200.0
2008-01-28 06:00:00	QQQ	ETF	43.54	43.54	43.47	43.47	2100.0
2008-01-28 06:30:00	QQQ	ETF	43.48	43.56	43.48	43.56	7400.0
2008-01-28 07:00:00	QQQ	ETF	43.58	43.73	43.57	43.7	40350.0
2008-01-28 07:30:00	QQQ	ETF	43.75	43.8	43.73	43.77	351696.0
2008-01-28 08:00:00	QQQ	ETF	43.78	43.94	43.47	43.89	1128241.0
2008-01-28 08:30:00	QQQ	ETF	43.89	43.97	43.82	43.93	1119193.0
2008-01-28 09:00:00	QQQ	ETF	43.94	44.07	43.9	44.02	1464335.0
2008-01-28 09:30:00	QQQ	ETF	44.03	44.05	43.57	43.95	28781428.0
2008-01-28 10:00:00	QQQ	ETF	43.95	44.13	43.61	44.1086	15581464.0
2008-01-28 10:30:00	QQQ	ETF	44.11	44.29	43.96	44.2	16696283.0
2008-01-28 11:00:00	QQQ	ETF	44.2	44.3	44.06	44.22	7554172.0
2008-01-28 11:30:00	QQQ	ETF	44.21	44.38	44.16	44.18	6615658.0
2008-01-28 12:00:00	QQQ	ETF	44.19	44.24	44.04	44.12	5558979.0
2008-01-28 12:30:00	QQQ	ETF	44.13	44.22	44.04	44.14	4065501.0
2008-01-28 13:00:00	QQQ	ETF	44.15	44.39	44.14	44.3	6832720.0
2008-01-28 13:30:00	QQQ	ETF	44.292	44.37	44.18	44.25	5658581.0
2008-01-28 14:00:00	QQQ	ETF	44.25	44.44	44.25	44.32	9346132.0
2008-01-28 14:30:00	QQQ	ETF	44.33	44.4	44.14	44.15	9881040.0
2008-01-28 15:00:00	QQQ	ETF	44.15	44.21	43.83	43.96	19056916.0

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

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