PREVIEW / etf_30min / 2008-02-27

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-27.parquet
  size:    154 KB
  rows:    5,545

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-27 04:00:00	SPY	ETF	138.11	138.11	138.11	138.11	1000.0
2008-02-27 04:30:00	SPY	ETF	138.12	138.16	138.02	138.02	4500.0
2008-02-27 05:00:00	SPY	ETF	137.9	137.93	137.9	137.93	1800.0
2008-02-27 05:30:00	SPY	ETF	138.16	138.16	138.16	138.16	2500.0
2008-02-27 06:00:00	SPY	ETF	138.2	138.2	138.0	138.0	50300.0
2008-02-27 06:30:00	SPY	ETF	138.15	138.32	138.15	138.31	48400.0
2008-02-27 07:00:00	SPY	ETF	138.2	138.25	138.05	138.17	175600.0
2008-02-27 07:30:00	SPY	ETF	138.18	138.21	137.85	137.9	798000.0
2008-02-27 08:00:00	SPY	ETF	137.93	138.21	137.41	137.64	3460700.0
2008-02-27 08:30:00	SPY	ETF	137.62	137.78	137.3	137.57	3078900.0
2008-02-27 09:00:00	SPY	ETF	137.57	137.62	137.41	137.56	1067000.0
2008-02-27 09:30:00	SPY	ETF	137.56	138.1	137.41	138.01	17485265.0
2008-02-27 10:00:00	SPY	ETF	138.01	138.29	137.62	137.62	17615852.0
2008-02-27 10:30:00	SPY	ETF	137.62	139.14	137.58	138.67	28845600.0
2008-02-27 11:00:00	SPY	ETF	138.67	138.99	138.52	138.6	9624628.0
2008-02-27 11:30:00	SPY	ETF	138.6	139.06	138.53	139.02	7381776.0
2008-02-27 12:00:00	SPY	ETF	139.03	139.03	138.56	138.64	6834916.0
2008-02-27 12:30:00	SPY	ETF	138.64	139.01	138.59	138.89	4769216.0
2008-02-27 13:00:00	SPY	ETF	138.89	139.03	138.66	138.8	5339344.0
2008-02-27 13:30:00	SPY	ETF	138.81	138.9	138.29	138.37	8435366.0
2008-02-27 14:00:00	SPY	ETF	138.37	138.63	137.66	137.77	13450056.0
2008-02-27 14:30:00	SPY	ETF	137.76	138.5	137.74	138.31	9672015.0
2008-02-27 15:00:00	SPY	ETF	138.3	138.6	137.99	138.51	8392892.0
2008-02-27 15:30:00	SPY	ETF	138.51	138.59	137.99	138.12	16755141.0
2008-02-27 16:00:00	SPY	ETF	138.09	138.4	137.65	138.18	2190400.0
2008-02-27 16:30:00	SPY	ETF	138.2	138.27	138.11	138.27	376100.0
2008-02-27 17:00:00	SPY	ETF	138.26	138.31	138.19	138.25	491100.0
2008-02-27 17:30:00	SPY	ETF	138.21	138.35	138.21	138.3	116800.0
2008-02-27 18:00:00	SPY	ETF	138.3	138.3	138.06	138.13	90500.0
2008-02-27 18:30:00	SPY	ETF	138.13	138.14	137.92	137.96	27700.0
2008-02-27 19:00:00	SPY	ETF	137.95	137.98	137.86	137.87	21500.0
2008-02-27 19:30:00	SPY	ETF	137.83	137.89	137.8	137.8	15300.0
2008-02-27 06:30:00	QQQ	ETF	44.06	44.08	44.02	44.08	50200.0
2008-02-27 07:00:00	QQQ	ETF	44.04	44.08	44.0	44.06	7043.0
2008-02-27 07:30:00	QQQ	ETF	44.04	44.04	43.89	43.9	259781.0
2008-02-27 08:00:00	QQQ	ETF	43.92	43.99	43.74	43.81	1855452.0
2008-02-27 08:30:00	QQQ	ETF	43.8	43.86	43.71	43.75	892418.0
2008-02-27 09:00:00	QQQ	ETF	43.77	43.8	43.72	43.77	547237.0
2008-02-27 09:30:00	QQQ	ETF	43.77	44.0	43.67	43.95	18113502.0
2008-02-27 10:00:00	QQQ	ETF	43.95	44.07	43.8	43.85	9399993.0
2008-02-27 10:30:00	QQQ	ETF	43.86	44.43	43.84	44.2	17120485.0
2008-02-27 11:00:00	QQQ	ETF	44.2	44.38	44.15	44.23	8958151.0
2008-02-27 11:30:00	QQQ	ETF	44.23	44.45	44.19	44.43	7608724.0
2008-02-27 12:00:00	QQQ	ETF	44.4399	44.44	44.22	44.2599	5054045.0
2008-02-27 12:30:00	QQQ	ETF	44.25	44.46	44.21	44.37	3569280.0
2008-02-27 13:00:00	QQQ	ETF	44.36	44.42	44.26	44.34	5548870.0
2008-02-27 13:30:00	QQQ	ETF	44.35	44.38	44.09	44.15	5915463.0
2008-02-27 14:00:00	QQQ	ETF	44.14	44.16	43.88	43.91	9122793.0
2008-02-27 14:30:00	QQQ	ETF	43.91	44.29	43.91	44.27	5910345.0
2008-02-27 15:00:00	QQQ	ETF	44.2701	44.41	44.14	44.37	7183920.0

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

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