PREVIEW / etf_30min / 2009-09-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-09.parquet
  size:    231 KB
  rows:    7,635

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-09-09 04:00:00	SPY	ETF	102.45	102.49	102.44	102.44	1600.0
2009-09-09 04:30:00	SPY	ETF	102.48	102.56	102.48	102.56	400.0
2009-09-09 05:00:00	SPY	ETF	102.66	102.68	102.66	102.66	4161.0
2009-09-09 05:30:00	SPY	ETF	102.76	102.95	102.76	102.94	5700.0
2009-09-09 06:00:00	SPY	ETF	103.0	103.0	102.88	102.88	1298.0
2009-09-09 06:30:00	SPY	ETF	102.9	102.9	102.81	102.81	25800.0
2009-09-09 07:00:00	SPY	ETF	102.88	102.98	102.86	102.92	115800.0
2009-09-09 07:30:00	SPY	ETF	102.95	103.14	102.95	103.05	309467.0
2009-09-09 08:00:00	SPY	ETF	103.01	103.3	102.95	103.27	869660.0
2009-09-09 08:30:00	SPY	ETF	103.28	103.28	102.89	103.05	1004584.0
2009-09-09 09:00:00	SPY	ETF	103.04	103.15	103.0	103.11	580843.0
2009-09-09 09:30:00	SPY	ETF	103.12	103.43	102.8	103.23	20880201.0
2009-09-09 10:00:00	SPY	ETF	103.225	103.5	103.22	103.34	11075661.0
2009-09-09 10:30:00	SPY	ETF	103.34	103.44	103.24	103.36	6807362.0
2009-09-09 11:00:00	SPY	ETF	103.3601	103.76	103.36	103.73	8708247.0
2009-09-09 11:30:00	SPY	ETF	103.73	104.0	103.73	103.81	11986544.0
2009-09-09 12:00:00	SPY	ETF	103.819	103.87	103.77	103.83	3663079.0
2009-09-09 12:30:00	SPY	ETF	103.83	103.95	103.77	103.95	4802423.0
2009-09-09 13:00:00	SPY	ETF	103.94	104.08	103.8	103.88	10161664.0
2009-09-09 13:30:00	SPY	ETF	103.8899	103.94	103.78	103.82	6091796.0
2009-09-09 14:00:00	SPY	ETF	103.82	103.92	103.29	103.42	15370951.0
2009-09-09 14:30:00	SPY	ETF	103.41	103.56	103.18	103.33	13231573.0
2009-09-09 15:00:00	SPY	ETF	103.34	103.66	103.28	103.56	10348937.0
2009-09-09 15:30:00	SPY	ETF	103.57	103.91	103.42	103.76	18721848.0
2009-09-09 16:00:00	SPY	ETF	103.76	103.85	102.9784	103.75	6052424.0
2009-09-09 16:30:00	SPY	ETF	103.75	103.76	102.9784	103.69	3213028.0
2009-09-09 17:00:00	SPY	ETF	103.69	103.69	103.65	103.65	107652.0
2009-09-09 17:30:00	SPY	ETF	103.67	103.73	103.6	103.61	117700.0
2009-09-09 18:00:00	SPY	ETF	103.63	103.76	103.59	103.6	56965.0
2009-09-09 18:30:00	SPY	ETF	103.62	103.65	103.61	103.63	8100.0
2009-09-09 19:00:00	SPY	ETF	103.63	103.64	103.6	103.64	9746.0
2009-09-09 19:30:00	SPY	ETF	103.64	103.65	103.6	103.6	19946.0
2009-09-09 04:00:00	QQQ	ETF	40.53	40.53	40.53	40.53	645.0
2009-09-09 06:00:00	QQQ	ETF	40.67	40.67	40.67	40.67	200.0
2009-09-09 06:30:00	QQQ	ETF	40.65	40.65	40.65	40.65	500.0
2009-09-09 07:00:00	QQQ	ETF	40.67	40.72	40.67	40.69	30100.0
2009-09-09 07:30:00	QQQ	ETF	40.71	40.76	40.71	40.73	6186.0
2009-09-09 08:00:00	QQQ	ETF	40.72	40.82	40.69	40.8	146917.0
2009-09-09 08:30:00	QQQ	ETF	40.81	40.81	40.71	40.71	89128.0
2009-09-09 09:00:00	QQQ	ETF	40.72	40.78	40.7	40.77	619319.0
2009-09-09 09:30:00	QQQ	ETF	40.76	40.92	40.59	40.84	12005495.0
2009-09-09 10:00:00	QQQ	ETF	40.84	41.02	40.84	40.94	8734048.0
2009-09-09 10:30:00	QQQ	ETF	40.94	41.02	40.893	40.98	4686744.0
2009-09-09 11:00:00	QQQ	ETF	40.98	41.16	40.98	41.1499	3659636.0
2009-09-09 11:30:00	QQQ	ETF	41.15	41.29	41.15	41.22	8811129.0
2009-09-09 12:00:00	QQQ	ETF	41.22	41.22	41.17	41.21	3659227.0
2009-09-09 12:30:00	QQQ	ETF	41.21	41.24	41.16	41.2301	2980426.0
2009-09-09 13:00:00	QQQ	ETF	41.2399	41.27	41.14	41.1601	5452856.0
2009-09-09 13:30:00	QQQ	ETF	41.16	41.21	41.13	41.15	4443567.0
2009-09-09 14:00:00	QQQ	ETF	41.15	41.2	40.84	40.9	7007873.0

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

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