PREVIEW / etf_30min / 2008-09-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-09.parquet
  size:    181 KB
  rows:    6,200

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-09-09 04:00:00	SPY	ETF	127.58	127.58	127.58	127.58	100.0
2008-09-09 04:30:00	SPY	ETF	127.5	127.5	127.5	127.5	200.0
2008-09-09 05:30:00	SPY	ETF	127.44	127.44	127.44	127.44	3000.0
2008-09-09 06:00:00	SPY	ETF	127.68	127.73	127.63	127.63	2200.0
2008-09-09 06:30:00	SPY	ETF	127.68	127.75	127.49	127.54	179800.0
2008-09-09 07:00:00	SPY	ETF	127.51	127.92	127.51	127.77	712485.0
2008-09-09 07:30:00	SPY	ETF	127.76	127.83	127.65	127.76	327029.0
2008-09-09 08:00:00	SPY	ETF	127.77	127.82	126.72	127.49	2684783.0
2008-09-09 08:30:00	SPY	ETF	127.5	127.53	127.08	127.09	2645663.0
2008-09-09 09:00:00	SPY	ETF	127.09	127.29	126.98	127.11	1813760.0
2008-09-09 09:30:00	SPY	ETF	127.1	127.32	126.28	127.13	42113903.0
2008-09-09 10:00:00	SPY	ETF	127.23	127.36	126.23	126.3	33817107.0
2008-09-09 10:30:00	SPY	ETF	126.3	127.2127	125.25	125.43	33900672.0
2008-09-09 11:00:00	SPY	ETF	125.42	125.84	124.99	125.815	27217859.0
2008-09-09 11:30:00	SPY	ETF	125.815	125.87	125.35	125.3501	15744173.0
2008-09-09 12:00:00	SPY	ETF	125.36	125.54	125.09	125.29	12643296.0
2008-09-09 12:30:00	SPY	ETF	125.28	125.81	125.14	125.49	13497817.0
2008-09-09 13:00:00	SPY	ETF	125.5	125.87	125.23	125.281	18150580.0
2008-09-09 13:30:00	SPY	ETF	125.29	125.38	124.65	124.8	22142155.0
2008-09-09 14:00:00	SPY	ETF	124.79	124.91	124.42	124.62	23013269.0
2008-09-09 14:30:00	SPY	ETF	124.62	124.66	123.91	124.02	26530842.0
2008-09-09 15:00:00	SPY	ETF	124.0225	124.09	123.65	124.08	28269842.0
2008-09-09 15:30:00	SPY	ETF	124.08	124.3	122.92	122.94	41956977.0
2008-09-09 16:00:00	SPY	ETF	122.9	127.2127	122.8	123.12	12148210.0
2008-09-09 16:30:00	SPY	ETF	123.13	127.2127	122.88	122.99	4350739.0
2008-09-09 17:00:00	SPY	ETF	122.99	127.2127	122.99	123.07	4945239.0
2008-09-09 17:30:00	SPY	ETF	123.1	123.2	122.8	123.03	150661.0
2008-09-09 18:00:00	SPY	ETF	123.15	123.21	123.12	123.18	51713.0
2008-09-09 18:30:00	SPY	ETF	123.12	123.39	123.11	123.39	70880.0
2008-09-09 19:00:00	SPY	ETF	123.39	123.45	123.37	123.37	87200.0
2008-09-09 19:30:00	SPY	ETF	123.42	123.45	123.26	123.29	164322.0
2008-09-09 04:00:00	QQQ	ETF	43.44	43.45	43.44	43.45	500.0
2008-09-09 05:00:00	QQQ	ETF	43.5	43.5	43.5	43.5	3200.0
2008-09-09 05:30:00	QQQ	ETF	43.55	43.56	43.54	43.54	600.0
2008-09-09 06:00:00	QQQ	ETF	43.6	43.63	43.6	43.63	2100.0
2008-09-09 06:30:00	QQQ	ETF	43.63	43.65	43.6	43.6	74000.0
2008-09-09 07:00:00	QQQ	ETF	43.57	43.72	43.57	43.64	370500.0
2008-09-09 07:30:00	QQQ	ETF	43.61	43.63	43.57	43.6	182307.0
2008-09-09 08:00:00	QQQ	ETF	43.6	43.64	43.45	43.45	1188301.0
2008-09-09 08:30:00	QQQ	ETF	43.45	43.5	43.36	43.37	997528.0
2008-09-09 09:00:00	QQQ	ETF	43.37	43.44	43.34	43.35	1294678.0
2008-09-09 09:30:00	QQQ	ETF	43.36	43.79	43.29	43.71	27908367.0
2008-09-09 10:00:00	QQQ	ETF	43.71	43.72	43.37	43.39	18801285.0
2008-09-09 10:30:00	QQQ	ETF	43.3901	43.48	43.14	43.2201	14852864.0
2008-09-09 11:00:00	QQQ	ETF	43.23	43.4	43.0	43.26	15584700.0
2008-09-09 11:30:00	QQQ	ETF	43.25	43.34	43.16	43.1605	7379937.0
2008-09-09 12:00:00	QQQ	ETF	43.16	43.16	42.98	43.06	9178689.0
2008-09-09 12:30:00	QQQ	ETF	43.07	43.29	43.0005	43.18	7452249.0
2008-09-09 13:00:00	QQQ	ETF	43.17	43.42	42.99	43.02	18372902.0
2008-09-09 13:30:00	QQQ	ETF	43.01	43.38	42.8	42.85	12298761.0

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

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