PREVIEW / etf_30min / 2008-10-02

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-02.parquet
  size:    179 KB
  rows:    6,281

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-10-02 05:00:00	SPY	ETF	115.8	115.8	115.76	115.76	2200.0
2008-10-02 05:30:00	SPY	ETF	115.88	115.98	115.88	115.98	970.0
2008-10-02 06:00:00	SPY	ETF	115.88	116.1	115.84	115.95	30400.0
2008-10-02 06:30:00	SPY	ETF	115.77	115.87	115.65	115.87	12200.0
2008-10-02 07:00:00	SPY	ETF	115.84	115.88	115.48	115.58	155936.0
2008-10-02 07:30:00	SPY	ETF	115.56	115.78	115.05	115.09	811394.0
2008-10-02 08:00:00	SPY	ETF	115.12	116.45	114.74	115.04	2085420.0
2008-10-02 08:30:00	SPY	ETF	115.05	115.18	114.63	114.95	2897282.0
2008-10-02 09:00:00	SPY	ETF	114.95	115.26	114.89	114.96	1703739.0
2008-10-02 09:30:00	SPY	ETF	114.95	115.11	113.73	113.84	35379068.0
2008-10-02 10:00:00	SPY	ETF	113.84	113.84	113.08	113.37	28161345.0
2008-10-02 10:30:00	SPY	ETF	113.37	113.57	112.82	113.09	16503330.0
2008-10-02 11:00:00	SPY	ETF	113.1	113.21	112.06	112.78	26361630.0
2008-10-02 11:30:00	SPY	ETF	112.78	113.25	112.5	113.18	15078156.0
2008-10-02 12:00:00	SPY	ETF	113.17	113.47	112.75	112.82	13925894.0
2008-10-02 12:30:00	SPY	ETF	112.82	113.06	112.59	112.89	12871628.0
2008-10-02 13:00:00	SPY	ETF	112.9	112.9	112.1	112.51	15491099.0
2008-10-02 13:30:00	SPY	ETF	112.52	113.11	111.85	112.58	32665236.0
2008-10-02 14:00:00	SPY	ETF	112.58	112.92	112.0	112.0	18629223.0
2008-10-02 14:30:00	SPY	ETF	112.0	112.35	111.46	112.32	24182559.0
2008-10-02 15:00:00	SPY	ETF	112.32	112.4	111.41	111.59	22292869.0
2008-10-02 15:30:00	SPY	ETF	111.59	112.23	111.06	111.3	52578101.0
2008-10-02 16:00:00	SPY	ETF	111.35	116.0278	111.28	111.85	33803010.0
2008-10-02 16:30:00	SPY	ETF	111.87	116.0277	111.33	111.96	5163363.0
2008-10-02 17:00:00	SPY	ETF	111.94	116.1	111.79	111.85	2665664.0
2008-10-02 17:30:00	SPY	ETF	111.89	111.9	111.74	111.8	1075623.0
2008-10-02 18:00:00	SPY	ETF	111.82	111.9	111.52	111.9	279349.0
2008-10-02 18:30:00	SPY	ETF	111.89	112.15	111.86	111.95	143795.0
2008-10-02 19:00:00	SPY	ETF	111.94	112.05	111.91	112.04	12430.0
2008-10-02 19:30:00	SPY	ETF	112.04	112.12	111.95	112.11	13528.0
2008-10-02 05:00:00	QQQ	ETF	38.87	38.87	38.87	38.87	2000.0
2008-10-02 05:30:00	QQQ	ETF	38.85	38.85	38.85	38.85	2200.0
2008-10-02 06:00:00	QQQ	ETF	38.75	38.75	38.75	38.75	200.0
2008-10-02 06:30:00	QQQ	ETF	38.7	38.7	38.7	38.7	100.0
2008-10-02 07:00:00	QQQ	ETF	38.65	38.65	38.49	38.5	24100.0
2008-10-02 07:30:00	QQQ	ETF	38.52	38.56	38.35	38.37	164033.0
2008-10-02 08:00:00	QQQ	ETF	38.37	38.85	38.15	38.28	955971.0
2008-10-02 08:30:00	QQQ	ETF	38.32	38.36	38.11	38.25	797738.0
2008-10-02 09:00:00	QQQ	ETF	38.24	38.33	38.22	38.25	521342.0
2008-10-02 09:30:00	QQQ	ETF	38.26	38.26	37.65	37.66	18739896.0
2008-10-02 10:00:00	QQQ	ETF	37.66	37.67	37.24	37.36	20171132.0
2008-10-02 10:30:00	QQQ	ETF	37.348	37.5	37.1101	37.24	10834119.0
2008-10-02 11:00:00	QQQ	ETF	37.24	37.5	37.02	37.28	14252268.0
2008-10-02 11:30:00	QQQ	ETF	37.27	37.46	37.18	37.422	10867264.0
2008-10-02 12:00:00	QQQ	ETF	37.429	37.47	37.23	37.24	6496030.0
2008-10-02 12:30:00	QQQ	ETF	37.2499	37.35	37.16	37.3	6633639.0
2008-10-02 13:00:00	QQQ	ETF	37.2905	37.2979	36.94	37.1	10166204.0
2008-10-02 13:30:00	QQQ	ETF	37.1	37.29	36.98	37.19	17476993.0
2008-10-02 14:00:00	QQQ	ETF	37.19	37.29	36.89	36.9099	12167539.0
2008-10-02 14:30:00	QQQ	ETF	36.9	37.08	36.73	37.03	19208064.0

> showing 50 of 6,281 rows — these rows as CSV

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