PREVIEW / etf_30min / 2010-08-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-19.parquet
  size:    253 KB
  rows:    8,381

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
2010-08-19 04:00:00	SPY	ETF	109.13	109.29	109.11	109.12	6289.0
2010-08-19 04:30:00	SPY	ETF	109.31	109.31	109.29	109.3	600.0
2010-08-19 05:00:00	SPY	ETF	109.36	109.44	109.36	109.39	5270.0
2010-08-19 05:30:00	SPY	ETF	109.44	109.44	109.44	109.44	200.0
2010-08-19 06:00:00	SPY	ETF	109.43	109.85	109.43	109.79	25738.0
2010-08-19 06:30:00	SPY	ETF	109.79	109.81	109.7	109.77	21575.0
2010-08-19 07:00:00	SPY	ETF	109.76	109.8	109.66	109.67	128224.0
2010-08-19 07:30:00	SPY	ETF	109.66	109.76	109.61	109.76	644392.0
2010-08-19 08:00:00	SPY	ETF	109.73	110.0	109.64	109.85	2766704.0
2010-08-19 08:30:00	SPY	ETF	109.79	109.93	108.87	109.23	11568086.0
2010-08-19 09:00:00	SPY	ETF	109.22	109.34	109.16	109.21	1282380.0
2010-08-19 09:30:00	SPY	ETF	109.22	109.49	108.87	108.98	26167021.0
2010-08-19 10:00:00	SPY	ETF	108.98	109.01	108.0556	108.3	34233051.0
2010-08-19 10:30:00	SPY	ETF	108.3	108.43	107.92	108.21	15261550.0
2010-08-19 11:00:00	SPY	ETF	108.22	108.23	107.9	108.08	13631025.0
2010-08-19 11:30:00	SPY	ETF	108.09	108.1	107.43	107.62	24231590.0
2010-08-19 12:00:00	SPY	ETF	107.61	107.85	107.52	107.81	16147302.0
2010-08-19 12:30:00	SPY	ETF	107.81	107.91	107.65	107.84	8881776.0
2010-08-19 13:00:00	SPY	ETF	107.84	107.95	107.76	107.81	6372559.0
2010-08-19 13:30:00	SPY	ETF	107.81	107.8699	107.6	107.6299	7516088.0
2010-08-19 14:00:00	SPY	ETF	107.63	107.95	107.48	107.84	12037836.0
2010-08-19 14:30:00	SPY	ETF	107.85	108.03	107.7	107.85	18106460.0
2010-08-19 15:00:00	SPY	ETF	107.85	108.35	107.74	108.1	21472215.0
2010-08-19 15:30:00	SPY	ETF	108.1	108.22	107.87	107.92	24956949.0
2010-08-19 16:00:00	SPY	ETF	107.92	109.7897	107.495	107.68	8519988.0
2010-08-19 16:30:00	SPY	ETF	107.65	109.7897	107.62	107.79	5237969.0
2010-08-19 17:00:00	SPY	ETF	107.79	107.82	107.72	107.79	94315.0
2010-08-19 17:30:00	SPY	ETF	107.77	107.86	107.74	107.76	58265.0
2010-08-19 18:00:00	SPY	ETF	107.77	107.88	107.76	107.83	50380.0
2010-08-19 18:30:00	SPY	ETF	107.79	107.82	107.71	107.75	11687.0
2010-08-19 19:00:00	SPY	ETF	107.76	107.85	107.76	107.82	11745.0
2010-08-19 19:30:00	SPY	ETF	107.82	107.86	107.75	107.86	14350.0
2010-08-19 04:00:00	QQQ	ETF	45.2	45.2	45.2	45.2	200.0
2010-08-19 05:00:00	QQQ	ETF	45.25	45.25	45.25	45.25	111.0
2010-08-19 06:00:00	QQQ	ETF	45.35	45.45	45.35	45.45	800.0
2010-08-19 06:30:00	QQQ	ETF	45.4	45.42	45.4	45.42	1200.0
2010-08-19 07:00:00	QQQ	ETF	45.46	45.46	45.41	45.43	46286.0
2010-08-19 07:30:00	QQQ	ETF	45.4	45.45	45.37	45.45	439709.0
2010-08-19 08:00:00	QQQ	ETF	45.43	45.54	45.42	45.5	1506000.0
2010-08-19 08:30:00	QQQ	ETF	45.41	45.41	45.13	45.29	4291874.0
2010-08-19 09:00:00	QQQ	ETF	45.29	45.36	45.27	45.28	433181.0
2010-08-19 09:30:00	QQQ	ETF	45.28	45.46	45.19	45.24	8204490.0
2010-08-19 10:00:00	QQQ	ETF	45.23	45.235	44.88	44.9962	11806695.0
2010-08-19 10:30:00	QQQ	ETF	45.0	45.02	44.83	44.92	5483380.0
2010-08-19 11:00:00	QQQ	ETF	44.92	44.94	44.81	44.88	3788852.0
2010-08-19 11:30:00	QQQ	ETF	44.88	44.88	44.56	44.66	6453984.0
2010-08-19 12:00:00	QQQ	ETF	44.65	44.77	44.59	44.7628	4856628.0
2010-08-19 12:30:00	QQQ	ETF	44.76	44.81	44.71	44.79	1575587.0
2010-08-19 13:00:00	QQQ	ETF	44.785	44.85	44.75	44.77	1954811.0
2010-08-19 13:30:00	QQQ	ETF	44.77	44.82	44.71	44.72	1263994.0

> showing 50 of 8,381 rows — these rows as CSV

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