PREVIEW / etf_30min / 2009-04-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-14.parquet
  size:    218 KB
  rows:    7,176

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
2009-04-14 04:00:00	SPY	ETF	85.3	85.36	85.26	85.36	4550.0
2009-04-14 04:30:00	SPY	ETF	85.33	85.45	85.33	85.45	700.0
2009-04-14 05:00:00	SPY	ETF	85.53	85.61	85.53	85.57	600.0
2009-04-14 05:30:00	SPY	ETF	85.68	85.85	85.68	85.81	47715.0
2009-04-14 06:00:00	SPY	ETF	85.8	85.85	85.55	85.55	42900.0
2009-04-14 06:30:00	SPY	ETF	85.5	85.65	85.47	85.59	23564.0
2009-04-14 07:00:00	SPY	ETF	85.6	85.84	85.53	85.6	684699.0
2009-04-14 07:30:00	SPY	ETF	85.59	85.62	85.48	85.56	705184.0
2009-04-14 08:00:00	SPY	ETF	85.56	86.2	85.1357	86.07	5952108.0
2009-04-14 08:30:00	SPY	ETF	86.06	86.06	84.97	85.08	5309413.0
2009-04-14 09:00:00	SPY	ETF	85.08	85.15	84.93	85.02	1833403.0
2009-04-14 09:30:00	SPY	ETF	85.03	85.19	84.51	85.03	28578913.0
2009-04-14 10:00:00	SPY	ETF	85.03	85.37	84.55	85.36	21531877.0
2009-04-14 10:30:00	SPY	ETF	85.3601	85.76	85.33	85.51	18127455.0
2009-04-14 11:00:00	SPY	ETF	85.5	85.6	85.01	85.03	15445290.0
2009-04-14 11:30:00	SPY	ETF	85.03	85.3799	85.03	85.11	11013241.0
2009-04-14 12:00:00	SPY	ETF	85.11	85.1125	84.71	84.94	10649201.0
2009-04-14 12:30:00	SPY	ETF	84.9399	85.03	84.13	84.28	16725847.0
2009-04-14 13:00:00	SPY	ETF	84.2702	84.42	84.08	84.38	14015873.0
2009-04-14 13:30:00	SPY	ETF	84.37	84.49	84.18	84.4075	14753377.0
2009-04-14 14:00:00	SPY	ETF	84.41	84.68	84.1	84.6494	17737814.0
2009-04-14 14:30:00	SPY	ETF	84.64	84.7	84.31	84.7	11892149.0
2009-04-14 15:00:00	SPY	ETF	84.695	84.94	84.49	84.62	18287512.0
2009-04-14 15:30:00	SPY	ETF	84.62	84.77	84.15	84.31	36627808.0
2009-04-14 16:00:00	SPY	ETF	84.33	84.7	84.08	84.21	14895426.0
2009-04-14 16:30:00	SPY	ETF	84.21	84.8	83.86	83.9	3777687.0
2009-04-14 17:00:00	SPY	ETF	83.91	84.1	83.91	83.99	858658.0
2009-04-14 17:30:00	SPY	ETF	84.03	84.03	83.95	83.95	82204.0
2009-04-14 18:00:00	SPY	ETF	83.96	83.97	83.76	83.92	252692.0
2009-04-14 18:30:00	SPY	ETF	83.92	83.96	83.91	83.91	155455.0
2009-04-14 19:00:00	SPY	ETF	83.92	83.95	83.86	83.86	69280.0
2009-04-14 19:30:00	SPY	ETF	83.86	83.92	83.86	83.88	49269.0
2009-04-14 04:00:00	QQQ	ETF	32.71	32.71	32.71	32.71	295.0
2009-04-14 06:30:00	QQQ	ETF	32.82	32.82	32.79	32.79	200.0
2009-04-14 07:00:00	QQQ	ETF	32.79	32.85	32.79	32.83	281979.0
2009-04-14 07:30:00	QQQ	ETF	32.83	32.86	32.81	32.83	427008.0
2009-04-14 08:00:00	QQQ	ETF	32.84	33.02	32.83	32.99	1571066.0
2009-04-14 08:30:00	QQQ	ETF	32.99	32.99	32.63	32.65	1586538.0
2009-04-14 09:00:00	QQQ	ETF	32.65	32.69	32.6	32.69	1096060.0
2009-04-14 09:30:00	QQQ	ETF	32.69	32.77	32.54	32.76	13155259.0
2009-04-14 10:00:00	QQQ	ETF	32.75	32.7899	32.57	32.7474	11013641.0
2009-04-14 10:30:00	QQQ	ETF	32.75	32.88	32.73	32.78	6797514.0
2009-04-14 11:00:00	QQQ	ETF	32.78	32.83	32.57	32.572	10040234.0
2009-04-14 11:30:00	QQQ	ETF	32.58	32.69	32.57	32.63	4598405.0
2009-04-14 12:00:00	QQQ	ETF	32.63	32.64	32.54	32.61	3323958.0
2009-04-14 12:30:00	QQQ	ETF	32.61	32.63	32.33	32.369	8199976.0
2009-04-14 13:00:00	QQQ	ETF	32.37	32.4395	32.27	32.42	9012796.0
2009-04-14 13:30:00	QQQ	ETF	32.42	32.47	32.34	32.43	5759573.0
2009-04-14 14:00:00	QQQ	ETF	32.43	32.52	32.36	32.5	5903860.0
2009-04-14 14:30:00	QQQ	ETF	32.4993	32.61	32.43	32.6	7388669.0

> showing 50 of 7,176 rows — these rows as CSV

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