PREVIEW / etf_30min / 2008-07-28

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-28.parquet
  size:    166 KB
  rows:    5,679

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-07-28 04:00:00	SPY	ETF	125.34	125.34	125.3	125.3	300.0
2008-07-28 04:30:00	SPY	ETF	125.45	125.45	125.45	125.45	800.0
2008-07-28 05:00:00	SPY	ETF	125.35	125.35	125.35	125.35	1000.0
2008-07-28 05:30:00	SPY	ETF	125.38	125.38	125.11	125.11	1200.0
2008-07-28 06:00:00	SPY	ETF	125.11	125.12	125.1	125.12	10130.0
2008-07-28 06:30:00	SPY	ETF	125.21	125.21	125.18	125.18	1500.0
2008-07-28 07:00:00	SPY	ETF	125.24	125.47	125.13	125.35	299420.0
2008-07-28 07:30:00	SPY	ETF	125.35	125.6	125.34	125.6	352249.0
2008-07-28 08:00:00	SPY	ETF	125.59	125.64	125.44	125.46	355835.0
2008-07-28 08:30:00	SPY	ETF	125.46	125.55	125.3	125.44	509433.0
2008-07-28 09:00:00	SPY	ETF	125.43	125.54	125.37	125.48	467490.0
2008-07-28 09:30:00	SPY	ETF	125.51	125.98	125.43	125.68	19886221.0
2008-07-28 10:00:00	SPY	ETF	125.68	126.06	125.54	125.72	14713306.0
2008-07-28 10:30:00	SPY	ETF	125.72	125.8	125.42	125.51	11474355.0
2008-07-28 11:00:00	SPY	ETF	125.5	125.53	125.03	125.12	11851551.0
2008-07-28 11:30:00	SPY	ETF	125.12	125.21	124.76	124.95	16162142.0
2008-07-28 12:00:00	SPY	ETF	124.95	125.13	124.86	124.95	9208469.0
2008-07-28 12:30:00	SPY	ETF	124.94	125.09	124.25	124.35	13053055.0
2008-07-28 13:00:00	SPY	ETF	124.36	125.53	124.2	124.369	9459955.0
2008-07-28 13:30:00	SPY	ETF	124.36	125.53	124.11	124.3	11539615.0
2008-07-28 14:00:00	SPY	ETF	124.3	124.41	123.97	124.03	10793807.0
2008-07-28 14:30:00	SPY	ETF	124.04	124.56	123.86	123.92	18628957.0
2008-07-28 15:00:00	SPY	ETF	123.92	124.29	123.87	124.1101	11005026.0
2008-07-28 15:30:00	SPY	ETF	124.115	124.15	123.42	123.57	26792704.0
2008-07-28 16:00:00	SPY	ETF	123.58	125.35	123.47	123.56	11038718.0
2008-07-28 16:30:00	SPY	ETF	123.59	125.7881	123.53	123.53	1829197.0
2008-07-28 17:00:00	SPY	ETF	123.55	123.59	123.45	123.45	136274.0
2008-07-28 17:30:00	SPY	ETF	123.45	123.58	123.2	123.58	220070.0
2008-07-28 18:00:00	SPY	ETF	123.52	123.81	123.51	123.76	175455.0
2008-07-28 18:30:00	SPY	ETF	123.73	123.79	123.73	123.79	14811.0
2008-07-28 19:00:00	SPY	ETF	123.77	123.77	123.62	123.69	14560.0
2008-07-28 19:30:00	SPY	ETF	123.71	123.73	123.65	123.68	32207.0
2008-07-28 07:00:00	QQQ	ETF	45.13	45.24	45.07	45.24	7900.0
2008-07-28 07:30:00	QQQ	ETF	45.22	45.31	45.2	45.31	43700.0
2008-07-28 08:00:00	QQQ	ETF	45.32	45.32	45.24	45.28	111925.0
2008-07-28 08:30:00	QQQ	ETF	45.27	45.28	45.2	45.25	80724.0
2008-07-28 09:00:00	QQQ	ETF	45.23	45.27	45.2	45.25	241300.0
2008-07-28 09:30:00	QQQ	ETF	45.25	45.52	45.14	45.19	19783778.0
2008-07-28 10:00:00	QQQ	ETF	45.19	45.36	45.18	45.33	9235468.0
2008-07-28 10:30:00	QQQ	ETF	45.33	45.36	45.14	45.18	7383608.0
2008-07-28 11:00:00	QQQ	ETF	45.171	45.19	44.91	44.93	8144759.0
2008-07-28 11:30:00	QQQ	ETF	44.94	44.96	44.79	44.93	8488293.0
2008-07-28 12:00:00	QQQ	ETF	44.92	44.95	44.84	44.87	4217205.0
2008-07-28 12:30:00	QQQ	ETF	44.87	44.92	44.59	44.64	7084845.0
2008-07-28 13:00:00	QQQ	ETF	44.63	44.76	44.57	44.68	4869320.0
2008-07-28 13:30:00	QQQ	ETF	44.6774	44.78	44.58	44.6999	4462029.0
2008-07-28 14:00:00	QQQ	ETF	44.7	44.74	44.42	44.43	8085273.0
2008-07-28 14:30:00	QQQ	ETF	44.42	44.64	44.35	44.36	8846509.0
2008-07-28 15:00:00	QQQ	ETF	44.36	44.58	44.36	44.48	5280625.0
2008-07-28 15:30:00	QQQ	ETF	44.48	44.5	44.21	44.4	14842906.0

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

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