PREVIEW / etf_30min / 2008-02-07

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-07.parquet
  size:    156 KB
  rows:    5,500

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-02-07 04:00:00	SPY	ETF	133.03	133.2	132.95	133.2	2100.0
2008-02-07 04:30:00	SPY	ETF	133.2	133.2	133.08	133.08	400.0
2008-02-07 05:00:00	SPY	ETF	133.07	133.13	133.07	133.11	7600.0
2008-02-07 05:30:00	SPY	ETF	133.02	133.02	132.9	132.9	8500.0
2008-02-07 06:00:00	SPY	ETF	132.77	132.77	132.49	132.55	18900.0
2008-02-07 06:30:00	SPY	ETF	132.52	132.76	132.52	132.76	45500.0
2008-02-07 07:00:00	SPY	ETF	132.75	132.9	132.3	132.32	1355000.0
2008-02-07 07:30:00	SPY	ETF	132.35	132.37	131.47	131.82	2199800.0
2008-02-07 08:00:00	SPY	ETF	131.82	132.32	131.29	131.61	3266600.0
2008-02-07 08:30:00	SPY	ETF	131.61	131.8	131.25	131.57	3353500.0
2008-02-07 09:00:00	SPY	ETF	131.58	132.13	131.54	132.09	4339219.0
2008-02-07 09:30:00	SPY	ETF	132.1	132.84	131.73	131.96	30619503.0
2008-02-07 10:00:00	SPY	ETF	131.96	133.87	131.8	133.18	45391614.0
2008-02-07 10:30:00	SPY	ETF	133.17	133.34	132.49	132.87	19104699.0
2008-02-07 11:00:00	SPY	ETF	132.86	133.12	132.3	132.43	12358291.0
2008-02-07 11:30:00	SPY	ETF	132.44	132.9	132.21	132.82	11551038.0
2008-02-07 12:00:00	SPY	ETF	132.82	133.05	132.64	133.0	8327589.0
2008-02-07 12:30:00	SPY	ETF	133.0	133.76	132.95	133.69	15441299.0
2008-02-07 13:00:00	SPY	ETF	133.7	133.92	133.11	133.6901	13905343.0
2008-02-07 13:30:00	SPY	ETF	133.7	134.58	133.55	134.47	14947920.0
2008-02-07 14:00:00	SPY	ETF	134.51	134.79	133.62	133.96	23752129.0
2008-02-07 14:30:00	SPY	ETF	133.95	133.96	133.0	133.12	22451595.0
2008-02-07 15:00:00	SPY	ETF	133.12	133.68	132.33	133.22	27447065.0
2008-02-07 15:30:00	SPY	ETF	133.249	133.8	132.98	133.78	22050414.0
2008-02-07 16:00:00	SPY	ETF	133.82	134.3	133.68	134.0	4206800.0
2008-02-07 16:30:00	SPY	ETF	134.0	134.07	132.71	133.93	5154000.0
2008-02-07 17:00:00	SPY	ETF	133.93	134.17	133.93	134.12	326400.0
2008-02-07 17:30:00	SPY	ETF	134.01	134.12	134.01	134.06	2300.0
2008-02-07 18:00:00	SPY	ETF	134.1	134.25	133.99	134.02	92600.0
2008-02-07 18:30:00	SPY	ETF	134.0	134.01	133.71	133.73	47900.0
2008-02-07 19:00:00	SPY	ETF	133.72	133.9	133.7	133.84	24100.0
2008-02-07 19:30:00	SPY	ETF	133.86	133.95	133.78	133.95	16400.0
2008-02-07 04:30:00	QQQ	ETF	42.49	42.52	42.49	42.52	1200.0
2008-02-07 06:30:00	QQQ	ETF	42.36	42.36	42.34	42.34	3500.0
2008-02-07 07:00:00	QQQ	ETF	42.37	42.4	42.34	42.35	116711.0
2008-02-07 07:30:00	QQQ	ETF	42.33	42.34	42.11	42.14	740303.0
2008-02-07 08:00:00	QQQ	ETF	42.14	42.3	42.06	42.12	1490844.0
2008-02-07 08:30:00	QQQ	ETF	42.11	42.2	42.02	42.13	1308933.0
2008-02-07 09:00:00	QQQ	ETF	42.13	42.85	42.13	42.34	4075578.0
2008-02-07 09:30:00	QQQ	ETF	42.35	42.67	42.15	42.23	32734048.0
2008-02-07 10:00:00	QQQ	ETF	42.2295	43.07	42.2295	42.89	51726917.0
2008-02-07 10:30:00	QQQ	ETF	42.88	42.88	42.56	42.71	26633031.0
2008-02-07 11:00:00	QQQ	ETF	42.71	42.79	42.52	42.58	8748743.0
2008-02-07 11:30:00	QQQ	ETF	42.58	42.8	42.54	42.775	9311609.0
2008-02-07 12:00:00	QQQ	ETF	42.77	42.83	42.73	42.81	7738798.0
2008-02-07 12:30:00	QQQ	ETF	42.81	43.16	42.79	43.12	13223242.0
2008-02-07 13:00:00	QQQ	ETF	43.12	43.39	42.96	43.29	12740977.0
2008-02-07 13:30:00	QQQ	ETF	43.29	43.67	43.25	43.62	15488069.0
2008-02-07 14:00:00	QQQ	ETF	43.63	43.79	43.21	43.31	20586072.0
2008-02-07 14:30:00	QQQ	ETF	43.31	43.32	42.88	42.892	25820292.0

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

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