PREVIEW / etf_30min / 2008-04-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-14.parquet
  size:    151 KB
  rows:    5,453

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-04-14 04:00:00	SPY	ETF	133.08	133.14	133.04	133.14	39000.0
2008-04-14 04:30:00	SPY	ETF	133.18	133.18	132.95	133.09	102000.0
2008-04-14 05:00:00	SPY	ETF	133.09	133.27	133.08	133.18	70810.0
2008-04-14 05:30:00	SPY	ETF	133.22	133.25	133.04	133.16	60000.0
2008-04-14 06:00:00	SPY	ETF	133.01	133.1	132.67	132.67	268600.0
2008-04-14 06:30:00	SPY	ETF	132.71	132.75	132.71	132.75	7400.0
2008-04-14 07:00:00	SPY	ETF	132.8	132.82	132.69	132.72	480573.0
2008-04-14 07:30:00	SPY	ETF	132.75	132.85	132.62	132.63	397725.0
2008-04-14 08:00:00	SPY	ETF	132.63	133.37	132.45	132.58	2162840.0
2008-04-14 08:30:00	SPY	ETF	132.57	133.06	132.55	133.02	2526617.0
2008-04-14 09:00:00	SPY	ETF	133.0	133.28	132.96	133.2	1656735.0
2008-04-14 09:30:00	SPY	ETF	133.19	133.28	132.95	133.2	17756007.0
2008-04-14 10:00:00	SPY	ETF	133.2	133.38	132.74	132.93	20609628.0
2008-04-14 10:30:00	SPY	ETF	132.93	133.28	132.91	133.22	9934322.0
2008-04-14 11:00:00	SPY	ETF	133.21	133.3	132.68	132.79	9769485.0
2008-04-14 11:30:00	SPY	ETF	132.78	132.93	132.57	132.92	10313641.0
2008-04-14 12:00:00	SPY	ETF	132.91	133.25	132.77	133.24	11115839.0
2008-04-14 12:30:00	SPY	ETF	133.24	133.52	133.11	133.49	10880711.0
2008-04-14 13:00:00	SPY	ETF	133.48	133.54	133.04	133.22	8456920.0
2008-04-14 13:30:00	SPY	ETF	133.22	133.28	132.91	133.03	5916344.0
2008-04-14 14:00:00	SPY	ETF	133.03	133.09	132.83	132.93	7869386.0
2008-04-14 14:30:00	SPY	ETF	132.93	133.17	132.7	132.74	7885962.0
2008-04-14 15:00:00	SPY	ETF	132.74	132.87	132.63	132.66	9416431.0
2008-04-14 15:30:00	SPY	ETF	132.66	132.97	132.55	132.81	14642065.0
2008-04-14 16:00:00	SPY	ETF	132.81	133.0	132.77	132.96	2637276.0
2008-04-14 16:30:00	SPY	ETF	132.95	133.04	132.91	132.94	998824.0
2008-04-14 17:00:00	SPY	ETF	132.96	133.02	132.79	132.83	1124728.0
2008-04-14 17:30:00	SPY	ETF	132.86	132.97	132.86	132.96	20690.0
2008-04-14 18:00:00	SPY	ETF	132.92	132.94	132.8	132.85	47370.0
2008-04-14 18:30:00	SPY	ETF	132.87	132.87	132.85	132.85	600.0
2008-04-14 19:00:00	SPY	ETF	132.82	133.05	132.82	133.05	21674.0
2008-04-14 19:30:00	SPY	ETF	133.05	133.1	133.05	133.1	2606.0
2008-04-14 05:30:00	QQQ	ETF	44.3	44.3	44.28	44.28	300.0
2008-04-14 06:00:00	QQQ	ETF	44.22	44.24	44.17	44.17	2300.0
2008-04-14 06:30:00	QQQ	ETF	44.13	44.15	44.06	44.06	1300.0
2008-04-14 07:00:00	QQQ	ETF	44.13	44.13	44.01	44.04	176449.0
2008-04-14 07:30:00	QQQ	ETF	44.04	44.11	44.03	44.03	57632.0
2008-04-14 08:00:00	QQQ	ETF	44.03	44.04	43.94	43.95	400794.0
2008-04-14 08:30:00	QQQ	ETF	43.97	44.16	43.97	44.12	717839.0
2008-04-14 09:00:00	QQQ	ETF	44.12	44.26	44.1	44.22	908696.0
2008-04-14 09:30:00	QQQ	ETF	44.21	44.24	43.95	44.12	13717023.0
2008-04-14 10:00:00	QQQ	ETF	44.12	44.23	44.03	44.14	8556430.0
2008-04-14 10:30:00	QQQ	ETF	44.14	44.33	44.1	44.2899	6788640.0
2008-04-14 11:00:00	QQQ	ETF	44.29	44.35	44.04	44.08	6608451.0
2008-04-14 11:30:00	QQQ	ETF	44.07	44.15	43.99	44.15	4269877.0
2008-04-14 12:00:00	QQQ	ETF	44.15	44.31	44.08	44.3	6759258.0
2008-04-14 12:30:00	QQQ	ETF	44.31	44.48	44.24	44.4	8753881.0
2008-04-14 13:00:00	QQQ	ETF	44.4	44.44	44.29	44.3301	5657522.0
2008-04-14 13:30:00	QQQ	ETF	44.331	44.34	44.18	44.23	3716016.0
2008-04-14 14:00:00	QQQ	ETF	44.23	44.28	44.16	44.22	4286670.0

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

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