PREVIEW / etf_30min / 2008-03-27

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-27.parquet
  size:    155 KB
  rows:    5,576

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-27 04:30:00	SPY	ETF	133.27	133.27	133.27	133.27	100.0
2008-03-27 05:00:00	SPY	ETF	133.52	134.02	133.52	133.95	6500.0
2008-03-27 05:30:00	SPY	ETF	134.0	134.1	133.95	133.95	1100.0
2008-03-27 06:30:00	SPY	ETF	133.95	134.1	133.95	134.05	78400.0
2008-03-27 07:00:00	SPY	ETF	134.02	134.05	133.55	133.62	1115700.0
2008-03-27 07:30:00	SPY	ETF	133.58	133.81	133.47	133.75	312300.0
2008-03-27 08:00:00	SPY	ETF	133.71	133.98	133.47	133.61	3590900.0
2008-03-27 08:30:00	SPY	ETF	133.72	134.43	133.6	134.34	4167300.0
2008-03-27 09:00:00	SPY	ETF	134.33	134.34	134.13	134.19	1910789.0
2008-03-27 09:30:00	SPY	ETF	134.2	134.34	133.71	134.06	18531903.0
2008-03-27 10:00:00	SPY	ETF	134.06	134.14	133.0	133.08	22365716.0
2008-03-27 10:30:00	SPY	ETF	133.08	133.32	132.75	133.22	21113166.0
2008-03-27 11:00:00	SPY	ETF	133.21	133.59	133.03	133.4	13624986.0
2008-03-27 11:30:00	SPY	ETF	133.39	133.91	133.27	133.68	11689444.0
2008-03-27 12:00:00	SPY	ETF	133.68	134.24	133.55	134.2	14033836.0
2008-03-27 12:30:00	SPY	ETF	134.2	134.44	133.98	133.981	10240947.0
2008-03-27 13:00:00	SPY	ETF	133.98	134.31	133.1	133.86	8222698.0
2008-03-27 13:30:00	SPY	ETF	133.87	133.9391	133.1	133.31	16622161.0
2008-03-27 14:00:00	SPY	ETF	133.3	134.0	132.95	133.29	13775260.0
2008-03-27 14:30:00	SPY	ETF	133.29	134.05	133.28	133.44	15011569.0
2008-03-27 15:00:00	SPY	ETF	133.44	133.9	133.07	133.24	14685120.0
2008-03-27 15:30:00	SPY	ETF	133.24	133.34	132.36	132.45	26264557.0
2008-03-27 16:00:00	SPY	ETF	132.56	137.77	132.52	132.65	3408600.0
2008-03-27 16:30:00	SPY	ETF	132.71	133.94	132.68	132.85	1117800.0
2008-03-27 17:00:00	SPY	ETF	132.83	132.83	132.73	132.74	124200.0
2008-03-27 17:30:00	SPY	ETF	132.75	132.79	132.74	132.74	7100.0
2008-03-27 18:00:00	SPY	ETF	132.74	132.78	132.68	132.77	16200.0
2008-03-27 18:30:00	SPY	ETF	132.78	132.83	132.73	132.81	8100.0
2008-03-27 19:00:00	SPY	ETF	132.8	132.8	132.64	132.64	6900.0
2008-03-27 19:30:00	SPY	ETF	132.74	132.83	132.74	132.83	9000.0
2008-03-27 05:00:00	QQQ	ETF	44.48	44.6	44.48	44.58	12200.0
2008-03-27 05:30:00	QQQ	ETF	44.57	44.6	44.57	44.6	5000.0
2008-03-27 06:00:00	QQQ	ETF	44.56	44.61	44.56	44.59	13795.0
2008-03-27 06:30:00	QQQ	ETF	44.55	44.6	44.53	44.56	49428.0
2008-03-27 07:00:00	QQQ	ETF	44.56	44.57	44.32	44.32	1305735.0
2008-03-27 07:30:00	QQQ	ETF	44.31	44.34	44.27	44.29	1434401.0
2008-03-27 08:00:00	QQQ	ETF	44.29	44.57	44.24	44.29	3774468.0
2008-03-27 08:30:00	QQQ	ETF	44.32	44.53	44.3	44.51	2391315.0
2008-03-27 09:00:00	QQQ	ETF	44.51	44.51	44.4	44.43	1016830.0
2008-03-27 09:30:00	QQQ	ETF	44.43	44.49	44.25	44.4025	12345067.0
2008-03-27 10:00:00	QQQ	ETF	44.4	44.41	44.04	44.05	11783289.0
2008-03-27 10:30:00	QQQ	ETF	44.05	44.13	43.96	44.1	11596528.0
2008-03-27 11:00:00	QQQ	ETF	44.0995	44.18	44.01	44.15	5971938.0
2008-03-27 11:30:00	QQQ	ETF	44.14	44.41	44.1	44.31	9603713.0
2008-03-27 12:00:00	QQQ	ETF	44.31	44.45	44.25	44.43	8647753.0
2008-03-27 12:30:00	QQQ	ETF	44.43	44.51	44.31	44.32	6246405.0
2008-03-27 13:00:00	QQQ	ETF	44.32	44.42	44.23	44.26	4533372.0
2008-03-27 13:30:00	QQQ	ETF	44.26	44.275	44.04	44.12	6634066.0
2008-03-27 14:00:00	QQQ	ETF	44.12	44.1225	43.95	44.04	12186002.0
2008-03-27 14:30:00	QQQ	ETF	44.04	44.25	44.0385	44.11	8194638.0

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

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