PREVIEW / etf_30min / 2008-08-13

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-13.parquet
  size:    172 KB
  rows:    5,956

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-08-13 05:30:00	SPY	ETF	129.24	129.24	129.24	129.24	2500.0
2008-08-13 06:00:00	SPY	ETF	129.1	129.27	129.1	129.26	52500.0
2008-08-13 06:30:00	SPY	ETF	129.09	129.2	129.08	129.11	280900.0
2008-08-13 07:00:00	SPY	ETF	129.11	129.19	129.0	129.03	281750.0
2008-08-13 07:30:00	SPY	ETF	129.06	129.11	128.83	128.86	347348.0
2008-08-13 08:00:00	SPY	ETF	128.86	129.25	128.56	128.72	1767977.0
2008-08-13 08:30:00	SPY	ETF	128.7	128.82	128.47	128.68	2177620.0
2008-08-13 09:00:00	SPY	ETF	128.69	128.81	128.67	128.79	702306.0
2008-08-13 09:30:00	SPY	ETF	128.79	128.94	128.23	128.5	27271574.0
2008-08-13 10:00:00	SPY	ETF	128.5	129.35	128.23	128.3001	17852381.0
2008-08-13 10:30:00	SPY	ETF	128.3	128.38	128.03	128.38	25960695.0
2008-08-13 11:00:00	SPY	ETF	128.37	128.38	127.85	128.09	16766131.0
2008-08-13 11:30:00	SPY	ETF	128.09	128.09	127.7225	127.87	12727861.0
2008-08-13 12:00:00	SPY	ETF	127.86	128.07	127.67	128.0	11763786.0
2008-08-13 12:30:00	SPY	ETF	127.99	128.25	127.91	128.2	9640786.0
2008-08-13 13:00:00	SPY	ETF	128.2	128.46	127.95	128.35	13153505.0
2008-08-13 13:30:00	SPY	ETF	128.35	129.05	128.35	128.9499	24604680.0
2008-08-13 14:00:00	SPY	ETF	128.95	129.11	128.67	128.68	12926574.0
2008-08-13 14:30:00	SPY	ETF	128.68	129.61	128.58	129.48	21428314.0
2008-08-13 15:00:00	SPY	ETF	129.49	129.65	128.92	129.12	20899088.0
2008-08-13 15:30:00	SPY	ETF	129.12	129.12	128.34	128.82	29905436.0
2008-08-13 16:00:00	SPY	ETF	128.82	129.4	127.8244	128.7	3366292.0
2008-08-13 16:30:00	SPY	ETF	128.66	128.76	128.6	128.66	414386.0
2008-08-13 17:00:00	SPY	ETF	128.65	128.66	128.63	128.65	35873.0
2008-08-13 17:30:00	SPY	ETF	128.65	128.69	128.65	128.69	2700.0
2008-08-13 18:00:00	SPY	ETF	128.7	128.73	128.64	128.7	60598.0
2008-08-13 18:30:00	SPY	ETF	128.74	128.77	128.74	128.77	4100.0
2008-08-13 19:00:00	SPY	ETF	128.68	128.72	128.65	128.72	24700.0
2008-08-13 19:30:00	SPY	ETF	128.66	128.77	128.65	128.75	45238.0
2008-08-13 04:00:00	QQQ	ETF	47.73	47.73	47.73	47.73	400.0
2008-08-13 05:30:00	QQQ	ETF	47.7	47.7	47.7	47.7	200.0
2008-08-13 06:30:00	QQQ	ETF	47.74	47.8	47.74	47.76	45700.0
2008-08-13 07:00:00	QQQ	ETF	47.8	47.83	47.79	47.83	123600.0
2008-08-13 07:30:00	QQQ	ETF	47.8	47.84	47.72	47.74	445800.0
2008-08-13 08:00:00	QQQ	ETF	47.74	47.83	47.67	47.69	2033837.0
2008-08-13 08:30:00	QQQ	ETF	47.7	47.79	47.65	47.68	783413.0
2008-08-13 09:00:00	QQQ	ETF	47.68	47.73	47.67	47.73	442238.0
2008-08-13 09:30:00	QQQ	ETF	47.74	47.9	47.61	47.7	18144329.0
2008-08-13 10:00:00	QQQ	ETF	47.7	47.93	47.62	47.74	14643806.0
2008-08-13 10:30:00	QQQ	ETF	47.74	47.8	47.53	47.72	14525394.0
2008-08-13 11:00:00	QQQ	ETF	47.72	47.73	47.5	47.55	8568939.0
2008-08-13 11:30:00	QQQ	ETF	47.55	47.58	47.26	47.3	13372904.0
2008-08-13 12:00:00	QQQ	ETF	47.2999	47.42	47.25	47.36	7670930.0
2008-08-13 12:30:00	QQQ	ETF	47.36	47.45	47.29	47.4074	6858031.0
2008-08-13 13:00:00	QQQ	ETF	47.41	47.59	47.31	47.55	9177967.0
2008-08-13 13:30:00	QQQ	ETF	47.54	47.75	47.53	47.73	12929444.0
2008-08-13 14:00:00	QQQ	ETF	47.73	47.82	47.6	47.75	13048645.0
2008-08-13 14:30:00	QQQ	ETF	47.76	48.06	47.7	48.05	12490062.0
2008-08-13 15:00:00	QQQ	ETF	48.05	48.12	47.77	47.82	11036108.0
2008-08-13 15:30:00	QQQ	ETF	47.83	47.83	47.58	47.78	18570459.0

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

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